Total Pageviews

Friday, October 10, 2014

simple sql command to update colum value

to update any value of the table in SQL, use below simple command

UPDATE "table_name"
SET "column_1" = [new value]
WHERE "condition";

make sure to commit after update otherwise value will not be saved for everyone to use

commit;
 

No comments:

Post a Comment