DELETE 语句用于删除表中的行。
语法如下
DELETE FROM 表名称 WHERE 列名称 = 值
例如:
DELETE FROM user WHERE name = 'Wilson'
当表名使用别名时,语法如下
DELETE 别名 FROM 表名称 别名 WHERE 列名称 = 值
例如:
DELETE t FROM user t WHERE name = 'Wilson'
如果写成
DELETE FROM user t WHERE name = 'Wilson'
会报以下错误
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't' at line 1