sql-update

Question 1

How do you update rows in a database table?

Answer 1

use the update statement ,
update “table name”
set “column name” = ‘value’
where “column name” = ‘value’;

Question 2

Why is it important to include a where clause in your update statements?

Answer 2

to specify which row you’re updating, if where clause is not included, it would update every row.