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
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