Encrypt function in MYSQL is not working!!
Posted: Mon Oct 10, 2005 3:06 am
Hello
I'm tryin this code in MYSQL:
but this is the error which I get:
MySQL said:
#1048 - Column 'PASSWORD' cannot be null
does this mean my system doesnt support the ENCRYPT fucntion!!
but when I use MD5 it fine, I'm running win xp IIS.
any help is much appreciated.
I'm tryin this code in MYSQL:
Code: Select all
insert into users (email, password, active, type) values ('someone@yahoo.com', encrypt('******'), 1,9)MySQL said:
#1048 - Column 'PASSWORD' cannot be null
does this mean my system doesnt support the ENCRYPT fucntion!!
but when I use MD5 it fine, I'm running win xp IIS.
any help is much appreciated.