Monday, December 11, 2006

UPDATE

The UPDATE statement is used to modify the data in a given row or all rows of a table. If are no row in the table nothing will be done.

Syntax:

UPDATE table_name SET column_value [WHERE column_name = some_value];

column_value :: column_name = new_value[, column_name = new_value ]

No comments: