1 使用详解
DELETE 语句
说明:用于删除表中的记录。
语法:
DELETE FROM table_name
[WHERE some_column operator some_value];
2 删除表中的记录(删除符合条件的记录)
删除users表中昵称包含'草'的用户。
DELETE FROM users
WHERE pickname like '%草%';
3 删除表中的记录(删除所有记录)
删除users表的所有记录。
DELETE FROM users;
DELETE 语句
说明:用于删除表中的记录。
语法:
DELETE FROM table_name
[WHERE some_column operator some_value];
删除users表中昵称包含'草'的用户。
DELETE FROM users
WHERE pickname like '%草%';
删除users表的所有记录。
DELETE FROM users;