sql-update Flashcards

1
Q

How do you update rows in a database table?

A

using the update statement then the name of the table you want to update the row on

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 you do not it will update all rows to that value instead of the one row you wanted

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