1 alter table `student` rename as `stu``lesson`

 2

 3 create table `student` (

 4 `id` int(4) auto_increment,

 5 `name` varchar(30),

 6 primary key(`id`)

 7 )engine=innodb default charset=utf8

 8

 9 insert into `student`(`name`) value('李四')

10

11 insert into `student`(`name`) value('李四')

12

13 update `student` set `name`='王五' where id=1

14

15 INSERT INTO `student`(`name`) VALUE('张三')

16

17 select * from student

18

19 select `id` from `student`

20

21 select `name` from `student`

22

23 SELECT `name` AS 姓名 FROM `student`

24

25 SELECT concat('名字：',`name`) AS 新姓名 FROM `student`

26

27 select * from `student`

28 select `name` from `student`

29 select distinct `name` from `student`

30

31 select version()

32

33 select `id`+1 from `student`

34 -

35 select `name` from `student` where `name` like '%三'