How To Update Values in a Table?

Answer 1

If you want to update some values in one row or multiple rows in a table, you can use the UPDATE statement. The script below shows a good example:

UPDATE temp_links SET counts = 999, notes = 'Good site.'
  WHERE id = 101;
1 row updated.

SELECT * FROM temp_links WHERE id = 101;
  ID URL                      NOTES      COUNTS CREATED
---- ------------------------ ---------- ------ ---------
 101 dev.tempsite.com Good site.    999 07-MAY-06