Sql Delete Flashcards

1
Q

How do you delete rows from a database table?

A

delete
from “table”
where “target ID” (unique identifier)

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

forget the where tag

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