SQL简单表user创建

CREATE TABLE `user` (
    `uid` INT PRIMARY KEY AUTO_INCREMENT,
    `uname` VARCHAR(30) NOT    NULL,
    `pwd` VARCHAR(30) NOT NULL
);
insert into `user` (`uid`, `uname`, `pwd`) values('1','admin','123');
insert into `user` (`uid`, `uname`, `pwd`) values('2','王小二','111');
insert into `user` (`uid`, `uname`, `pwd`) values('3','张三风','222');
insert into `user` (`uid`, `uname`, `pwd`) values('4','王大拿','333');
insert into `user` (`uid`, `uname`, `pwd`) values('6','admin1','122');
insert into `user` (`uid`, `uname`, `pwd`) values('7','赵云','6766');