eharetea

Use the UPDATE statement to update data in a table.

Updating table data.

Date Created:Friday December 29th, 2006 03:41 AM
Date Modified:Friday August 01st, 2008 01:01 AM

# UPDATE is used to update data in a table after it has been added.

# updates one column:
UPDATE folders SET title='Dan' WHERE folder_id=2;

# updates multiple columns:
UPDATE folders SET title='Dan', parent_id='2', description='blah' WHERE folder_id=2;