create databases hhr;
create table student(id int(11)not null primary key auto_increment,name varchar(100)not null,age tinyint(4));
desc student
3.2 查看下该新建的表有无内容(用select语句)
select * from student;
3.3 往新建的student表中插入数据(用insert语句),结果应如下 所示:
±—±------------±-----+
| id | name | age |
±—±------------±-----+
| 1 | tom | 20 |
| 2 | jerry | 23 |
| 3 | wangqing | 25 |
| 4 | sean | 28 |
| 5 | zhangshan | 26 |
| 6 | zhangshan | 20 |
| 7 | lisi | NULL |
| 8 | chenshuo | 10 |
| 9 | wangwu | 3 |
| 10 | qiuyi | 15 |
| 11 | qiuxiaotian | 20 |
±—±------------±-----+
insert student(name,age) value(‘tom’,20),(‘jerry’,23),(‘wangqing’,25),(‘sean’,28),
(‘z