今天学习并练习了数据库的删除语句。
DELETE 语句用于删除表中的行。
语法:
DELETE FROM table_name
WHERE some_column=some_value;
也可以删除所有数据:
DELETE FROM table_name;
或
DELETE * FROM table_name;
今天学习并练习了数据库的删除语句。
DELETE 语句用于删除表中的行。
语法:
DELETE FROM table_name
WHERE some_column=some_value;
也可以删除所有数据:
DELETE FROM table_name;
或
DELETE * FROM table_name;