How to delete data from a SQL database table, and how to delete the table
To remove data from a table, use the DELETE FROM
command.
This deletes all rows:
DELETE FROM people;
You can use the WHERE
clause to only remove specific rows:
DELETE FROM people WHERE name='Flavio';
To delete a table instead of the data inside the table, use the DROP TABLE
command:
DROP TABLE people;