0

http://www.cahilig.net

Here's how to update existing data into MySQL database table.

update table set column='new_value' where where_condition;

The update statement updates columns of existing rows in the table with new values.
The table is the table name.
The set clause indicates which column to modify and the values they should be given.
The where clause specifies the conditions that identify which rows to update. Its very useful if you want to update selected rows in a table.
Example:

Full story »
chr05210084's picture
Created by chr05210084 14 years 12 weeks ago
Category: Beginner   Tags:

Best karma users