个人观点: password用于修改mysql的用户密码,如果是应用与web程序建议使用md5()函数, insert into users(names,pwd) values('aa',md5('123456')) php "select * from users where name='".$HTTP_POST_VARS['uname']."' and pwd=md5('".$HTTP_POST_VARS['upass']."')"
select * from userinfo where username='aa' and password=password('123456')写法应该没错,你也没把具体的出错信息写出来,这样也不太清楚,另外就是最好别用保留字一类的字符串作为字段名,有时会莫名其妙的出错!!
没错啊
password()函数使用没有错误啊!
password用于修改mysql的用户密码,如果是应用与web程序建议使用md5()函数,
insert into users(names,pwd) values('aa',md5('123456'))
php "select * from users where name='".$HTTP_POST_VARS['uname']."' and pwd=md5('".$HTTP_POST_VARS['upass']."')"
SELECT LENGTH(PASSWORD('12345'));
SELECT length(old_password('12345'));