Question

mysql如何把user表的password字段32位MD5加密啊

UPDATE member SET password =md5(`password`) WHERE id =7234;像我这样写只会把“password”这个值加密，而不是把这个字段里的值加密我想把password这个字段做为md5的参数应该怎么做呢？

Answer 1

整个字段值加密UPDATE member SET password=md5('password')

Answer 2

UPDATE member SET `password` =MD5(`password`)

Answer 3

UPDATE member SET password =md5(password) WHERE id =7234;

Answer 4

update member set password = md5(password);
没有引号。