update multiple column in mysql code example
Example: update multiple columns in mysql
UPDATE newpurchase
SET receive_qty = 20, pub_lang = 'Hindi', receive_dt = '2008-07-10'
WHERE purch_price > 50;
UPDATE newpurchase
SET receive_qty = 20, pub_lang = 'Hindi', receive_dt = '2008-07-10'
WHERE purch_price > 50;