sql-delete Flashcards

1
Q

How do you delete rows from a database table?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How do you accidentally delete all rows from a table?

A

if you didn’t include a where clause.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly