SQL语句增删改查

1、处理的表CREATETABLE`student`(`id`int(50)NOTNULLAUTO_INCREMENT,`name`varchar(50)DEFAULTNULL,`sex`varchar(48)DEFAULTNULL,`age`varchar(50)DEFAULTNULL,`birthday`varchar(50)DEFAULTNULL,PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=244DEFAULTCHARSET=utf8

2、查询ID为11的信息SELECT * FROM student WHERE id=11

3、插入一组数据INSERT INTO student(NAME,sex,age,birthday) VALUE('黄河涛涛h','男',23,1993)

4、删除一组数据DELETE FROM student WHERE student.name='李明'

5、修改一组数据