sql-update Flashcards

1
Q

How do you update rows in a database table?

A

update “table name”
set “attribute column name” = ‘value’ and no single quotes if it’s a number value
where keyword to specific places to update

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

it can update all the columns for all rows

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