sql update Flashcards

1
Q

How do you update rows in a database table?

A

update “list”

set “column” = ‘value’

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

If it isn’t included it will update all rows

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