SQL语法之DML操作

DML（Data Manipulation Language），数据操作语言，是对数据库中表的数据进行增删改，主要包括：insert delete update truncate 关键字。

#DML操作

#插入insert
INSERT INTO stu(sid,name,gender,age,birth,address,score)
						values(1001,'张三','男',18,'2001-12-23','北京',85.5),
									(1002,'李四','女',19,'2001-09-15','深圳',83.6);
									
INSERT INTO stu values(1003,'王五','男',20,'2000-06-18','上海',93.2),
											(1004,'张华','女',18,'2000-01-01','广州',96.6);
											
#数据修改update
UPDATE stu SET address='重庆';

UPDATE stu SET address='北京' where sid = 1004;

UPDATE stu SET address='广州',score = 100 where sid = 1002;

#数据删除delete truncate
DELETE FROM stu where sid = 1004;

#DELETE FROM stu 只清空表数据
#TRUNCATE TABLE stu 整个表删掉 并创建新表

DML练习

#DML练习

CREATE TABLE IF NOT EXISTS mydb1.employee(
		id int,
		name varchar(20),
		gender varchar(10),
		salary double
);

INSERT INTO employee(id,name,gender,salary)
						VALUES(1,'王明','男',12500),
									(2,'张敏','女',13450),
									(3,'李华','男',8000),
									(4,'刘娜','女',9000),
									(5,'黎明','男',10000);

UPDATE employee SET salary = 10600 WHERE name = '李华';

#+=语法不可以
UPDATE employee SET salary = salary + 1800 WHERE name = '刘娜';