mysql数据更新

• 插入数据

INSERT INTO tb_student ( studentNo, studentName, sex, birthday, native, nation, classNo )
VALUES
	( '2013110101', '张晓勇', '男', '1997-12-11', '山西', '汉', 'AC1301' ),
	( '2013110103', '王一敏', '女', '1996-03-25', '河北', '汉', 'AC1301' ),
	( '2013110201', '江山', '女', '1996-09-17', '内蒙', '锡伯', 'AC1302' ),
	( '2013110202', '李明', '男', '1996-01-14', '广西', '壮', 'AC1302' ),
	( '2013310101', '黄菊', '女', '1995-09-30', '北京', '汉', 'IS1301' ),
	( '2013110102', '林海', '男', '1996-01-18', '北京', '满', 'IS1301' ),
	( '2013310103', '吴昊', '男', '1995-11-18', '河北', '汉', 'IS1301' ),
	( '2014210101', '刘涛', '男', '1997-04-03', '湖南', '侗', 'CS1401' ),
	( '2014210102', '郭志坚', '男', '1997-02-21', '上海', '汉', 'CS1401' ),
	( '2014310101', '王林', '男', '1996-10-09', '河南', '汉', 'IS1401' );
	( '2014310102', '李怡然', '女', '1996-12-31', '辽宁', '汉', 'IS1401' );

插入完整数据记录

INSERT INTO tb_student ( studentNo, studentName, native, nation, sex, birthday, classNo )
VALUES
	( '2013110203', '孟颖', '上海', '汉', '女', '1997-03-20', 'AC1302' )

指定字段插入数据

INSERT INTO tb_student ( studentNo, studentName, sex, nation, classNo )
VALUES ('2014310103','孙新','男','傣','IS1401');

同时插入多条数据

INSERT INTO tb_student ( studentNo, studentName, sex )
VALUES
	( '2014310104', '陈卓卓', '女' ),
	( '2014310105', '马丽', '女' ),
	( '2014310106', '许江', '男' );

• 修改特定数据记录

UPDATE tb_student
SET studentName = '黄涛333',
native = '湖北',
nation = '汉'
WHERE
	studentNo = '2014210999';

修改所有数据记录

将成绩表 tb_score 中的所有学生的成绩提高 5%

UPDATE tb_score
SET score = score * 1.05;

• 删除记录

DELETE FROM tb_student WHERE studentName="王一敏";