Mysql纯方法

create table userinfo(
user_nid int auto_increment primary key not null,
user_name char(16) not null,
user_pwd varchar(64) not null,
user_email varchar(32) not null,
user_phone char(11) not null,
user_head varchar(64) not null,
unique uni_user_name (user_name)
)