MYSQL DML 修改和删除数据

点击查看代码

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;