1UPDATE tableName SET columnName = yourValue;
2#to update multiple columns:
3UPDATE tableName SET column1 = value1, column2 = value2; #and so on
1UPDATE t1 LEFT JOIN t2 ON t1.id = t2.f_key
2 SET t1.value = t1.value + 1,
3 t2.value = t2.value + 1
4 WHERE t1.id = condition
1UPDATE [LOW_PRIORITY] [IGNORE] table_name
2SET
3 column_name1 = expr1,
4 column_name2 = expr2,
5 ...
6[WHERE
7 condition];
1 update tabe2 set subject_id = (SELECT GROUP_CONCAT(sub_id SEPARATOR ', ') as sub_id FROM tabe1)
2
1UPDATE newpurchase
2SET receive_qty = 20, pub_lang = 'Hindi', receive_dt = '2008-07-10'
3WHERE purch_price > 50;