Updating multiple values in MySQL

Question

How can I update multiple values in MySQL?

This didn't work:

UPDATE test SET list=0,
price= 0.00 cprice= 0.00 WHERE test.id =3232

Rafid Aslam · Accepted Answer · 2021-05-07 10:03:53Z

66

You need to put a comma between the two different values, for example:

UPDATE orders 
   SET listPrice = 0,
       bloggerPrice = 0.00,
       customerPrice = 0.00 
WHERE orders.id =245745

Rafid Aslam

3173 silver badges11 bronze badges

answered Nov 2, 2009 at 16:11

northpole

10.3k7 gold badges38 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Willem van Ketwich · Accepted Answer · 2017-03-01 00:18:11Z

10

You're missing a comma:

UPDATE orders SET 
    listPrice = 0, 
    bloggerPrice = 0.00, 
    customerPrice = 0.00 
WHERE 
    orders.id = 245745

6,0547 gold badges54 silver badges59 bronze badges

answered Nov 2, 2009 at 16:10

Greg

323k55 gold badges378 silver badges338 bronze badges

James · Accepted Answer · 2009-11-02 16:10:50Z

8

Try:

UPDATE orders 
SET listprice=0, bloggerPrice=0.00, customerPrice=0.00 
WHERE id=245745

answered Nov 2, 2009 at 16:10

James

82.4k19 gold badges172 silver badges245 bronze badges