Question

mysql中建表怎么给密码加密,用MD5?

谁帮我建个mysql表，要有id，name，password，密码要用MD5加密，id设为主键

Answer 1

CREATE TABLE `tablename` (

`id` int(4) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=gb2312;
password 在输入后用PHP MD5()函数加密即可

Answer 2

CREATE TABLE `tablename` (

`id` int(4) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=gb2312;
MD5实现方法如下：
insert into tablename(name,password) values("wangkeyao",md5("dsb")) ;