Day 09 - DELETE FROM 知错能改善莫大焉!

我们前几篇学到了新增修改再来就轮到资料调处语言（Data Manipulation Language, DML）的老三删除啦!

DELETE FROM 语法 (SQL DELETE FROM Syntax)

DELETE FROM table_name
WHERE column_name = value;

一次删除资料表中所有的资料

DELETE FROM table_name

DELETE FROM 实例解说

我们利用客户资料表举例说明,如果陈阿美不想再把资料留给我们要求删除时,我们就可以利用DELETE来删除我们的资料。给大家看看效果。

客户资料表(guest)

我们删除这笔资料:

DELETE FROM guest WHERE 顾客姓名='陈阿美';

则资料表会更新成下表:

这样就成功删除资料啦!

下篇见~