sql-delete

Question 1

How do you delete rows from a database table?

Answer 1

DELETE FROM “tableName”
WHERE “thisColumn” = ‘hasThisValue’
RETURNING *;

Question 2

How do you accidentally delete all rows from a table?

Answer 2

by not using the WHERE clause