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′);