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 ggl_links SET counts = 999, notes = 'Good site.'

WHERE id = 101;

1 row updated.

SELECT * FROM ggl_links WHERE id = 101;

 ID URL    NOTES COUNTS CREATED

---- ------------------------ ---------- ------ ---------

 101 http://www.rendc.org Good site. 999 07-MAY-06