SQL语句增删改查

SQL语句增删改查

就是在MySQL上进行简单的增删改查

处理的表

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

查询ID为11的信息

SELECT * FROM student WHERE id=11

插入一组数据

INSERT INTO student(NAME,sex,age,birthday) VALUE('黄河涛涛h','男',23,1993)

删除一组数据

DELETE FROM student WHERE student.name='李明'

修改一组数据