Published Apr 02 2020
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;
© 2023 Flavio Copes
using
Notion to Site.
Follow on Twitter
Solopreneur? Wannabe? Adventure awaits