标签：SET 删除 -- DML UPDATE MYSQL employee WHERE SELECT
点击查看代码
UPDATE employee SET NAME = 'itheima' WHERE id = 1; -- 更改id1的name为
SELECT * FROM employee;
UPDATE employee SET NAME = '小昭', gender = '女' WHERE id =1 ; -- 更改ID1的name和gander
SELECT * FROM employee;
UPDATE employee SET entrydate = '2008-01-01'; -- 更改所有人的entrydate
SELECT * FROM employee;
点击查看代码
DELETE FROM employee WHERE gender = '女'; -- 删除gender为女的条目
SELECT * FROM employee;
DELETE FROM employee; -- 删除所有条目
SELECT * FROM employee;
标签：SET,
删除,
--,
DML,
UPDATE,
MYSQL,
employee,
WHERE,
SELECT
From： https://www.cnblogs.com/di7gan/p/18439162