sql-delete Flashcards

1
Q

How do you delete rows from a database table?

A

use the delete from statement followed by the table name, and then a where clause targeting the row(s) with the column name and value

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

by using the delete from statement and then the table name without the where clause specifying a specific row(s)

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