1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| -- 1. 创建表 create table user( id int primary key auto_increment, username varchar(50), password varchar(50), name varchar(20) not null, gender varchar(5), age int, address varchar(32), qq varchar(20), email varchar(50) ); -- 2. 插入数据 INSERT INTO USER(username,password,name,gender,age,address,qq,email) VALUES('zhangsan','123','张三','男',18,'北京','111','111@qq.com'), ('lisi','123','李四','女',19,'上海','222','222@qq.com'), ('wangwu','123','王五','男',20,'广州','333','333@qq.com'), ('zhaoliu','123','赵六','女',21,'深圳','444','444@qq.com'), ('sunqi','123','孙七','男',22,'北京','555','555@qq.com'), ('zhouba','123','周八','女',23,'上海','666','666@qq.com')
|