就是在MySQL上进行简单的增删改查
工具/原料
1
MySQL
2
SQLyog
方法/步骤
1
处理的表CREATE TABLE `student` ( `id` int(50) NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL, `sex` varchar(48) DEFAULT NULL, `age` varchar(50) DEFAULT NULL, `birthday` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=244 DEFAULT CHARSET=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
修改一组数据