sql-delete Flashcards
1
Q
How do you delete rows from a database table?
A
use the delete statement.
delete from “table name”
where “column name” = value
returning * (to show the deleted rows, optional)
2
Q
How do you accidentally delete all rows from a table?
A
if you didn’t include a where clause.