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),
(‘zhangshan’,26),(‘zhangshan’,20),(‘lisi’,NULL),(‘chenshuo’,10),(‘wangwu’,3),(‘qiuyi’,15),
(‘qiuxiaotian’,20);
3.4 修改lisi的年龄为50
update student set age = 50 where name = ‘lisi’;