sql-delete

Question 1

How do you delete rows from a database table?

Answer 1

delete from "products"
where "productId" = 24
And “name” = ‘shamwow’
And “price” < 20
returning *;

Question 2

How do you accidentally delete all rows from a table?

Answer 2

delete from “products”;

deletes all the rows but leaves the structure of the table in place.