sql-delete

Question 1

How do you delete rows from a database table?

Answer 1

delete statement with a where clause
delete from “products”
where “category” = ‘cleaning’
and “price” < 20

Question 2

How do you accidentally delete all rows from a table?

Answer 2

By omitting the where clause