sql-delete

Question 1

How do you delete rows from a database table?

Answer 1

Using the “delete from” clause. On the next line, enter the “where” clause followed by the name of the column in double quotes, followed by the operator, followed by the name of the value in single quotes.

delete from (name of table in double quotes)
  where (name of column in double quotes) = (name of value in single quotes)
returning *;  (this part is optional)

Question 2

How do you accidentally delete all rows from a table?

Answer 2

Using “delete from (name of table);” without the “where” clause.