dazz_club Posted April 14, 2008 Share Posted April 14, 2008 Hi guys and girls, I am setting up a database and would like to have my passwords encrpted by using MD5, however i am having trouble writing the sql syntax for this, here is what i have got so far; CREATE TABLE `SourceUK` ( `ID` INT NOT NULL AUTO_INCREMENT, `password` VARCHAR(50) NULL, <-------- where do i put MD5 in this syntax?? `username` VARCHAR(50) NULL, kind regards Dazzclub Quote Link to comment https://forums.phpfreaks.com/topic/101024-set-up-password-field-and-incorporatin-md5-using-sql-syntax/ Share on other sites More sharing options...
dazz_club Posted April 14, 2008 Author Share Posted April 14, 2008 no worries, there is no shortcut in using sql syntax,; just done it the long way Quote Link to comment https://forums.phpfreaks.com/topic/101024-set-up-password-field-and-incorporatin-md5-using-sql-syntax/#findComment-516646 Share on other sites More sharing options...
fenway Posted April 14, 2008 Share Posted April 14, 2008 no worries, there is no shortcut in using sql syntax,; just done it the long way That's right, you need to store it as MD5()... just make sure to encrypt it before you store it (i.e. in application code). Quote Link to comment https://forums.phpfreaks.com/topic/101024-set-up-password-field-and-incorporatin-md5-using-sql-syntax/#findComment-516730 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.