xxxxxxxxxx
UPDATE Table_name
-- The desired value
SET Column_name = desired_value
-- Any value, of the item, of which one value you want to change
WHERE Column_name = value
xxxxxxxxxx
UPDATE table_name SET field1 = new-value1, field2 = new-value2
[WHERE Clause]
xxxxxxxxxx
mysql> update updateIfConditionDemo set UserAge =if(UserAge =23,26,UserAge);
Query OK, 4 rows affected (0.20 sec)
Rows matched: 5 Changed: 4 Warnings: 0
xxxxxxxxxx
CREATE TABLE copy LIKE original;
ALTER TABLE copy DISABLE KEYS;
SET unique_checks=0; SET foreign_key_checks=0;
INSERT INTO copy SELECT * FROM original;
ALTER TABLE copy ENABLE KEYS;
SET unique_checks=1; SET foreign_key_checks=1;