SQL Update Flashcards

1
Q

How do you update rows in a database table?

A

update
then set value to what you want

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

to be precise on what you want to change instead of changing the whole document

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