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 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 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). 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
Archived
This topic is now archived and is closed to further replies.