sql-delete

Question 1

How do you delete rows from a database table?

Answer 1

use the delete statement.
delete from “table name”
where “column name” = value
returning * (to show the deleted rows, optional)

Question 2

How do you accidentally delete all rows from a table?

Answer 2

if you didn’t include a where clause.