sql删掉表后数据删不掉_SQL，如何删除数据和表

sql删掉表后数据删不掉

To remove data from a table, use the DELETE FROM command.

要从表中删除数据，请使用DELETE FROM命令。

This deletes all rows:

这将删除所有行：

DELETE FROM people;

You can use the WHERE clause to only remove specific rows:

您可以使用WHERE子句仅删除特定的行：

DELETE FROM people WHERE name='Flavio';

To delete a table instead of the data inside the table, use the DROP TABLE command:

要删除表而不是表中的数据，请使用DROP TABLE命令：

DROP TABLE people;

翻译自: https://flaviocopes.com/sql-delete-data/

sql删掉表后数据删不掉