SQL UPDATE Flashcards

1
Q

How do you update rows in a database table?

A

update “row” (“column”)
set to (‘whatever)

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

Why is it important to include a where clause in your update statements?

A

Need to specify of it will update all data

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