SQL multi SET with one WHERE

Question

Similar to this question : SQL Statement with multiple SETs and WHEREs

Is there a way to perform multiple sets, as shown below.

UPDATE  table
SET ID = 111111259
SET Name = "Bob"
SET Phone = 1111111261
WHERE ID = 2555

Thanks.

Thanks for the edit, I was figuring it out.. slowly :) – 2b77bee6-5445-4c77-b1eb-4df3e5 Jul 16 '14 at 15:26 — 2b77bee6-5445-4c77-b1eb-4df3e5, Jul 16 '14 at 15:26

score 15 · Accepted Answer · answered Jul 16 '14 at 15:27

15

This is possible,

UPDATE table SET Name = 'aaa', Col2 = 'bbb' WHERE ID IN (2555, 2666)

What you are asking for is setting multiple values to same column and same row.

answered Jul 16 '14 at 15:27

Matas Vaitkevicius

58,075
31
238
265

Sorry, i can see how my example is very unclear. I want to set multiple fields in one row. - i updated the question – 2b77bee6-5445-4c77-b1eb-4df3e5 Jul 16 '14 at 15:27

score 3 · Answer 2 · answered Jul 16 '14 at 15:27

3

No need of SET for each column. do it like

UPDATE  table
SET ID = 111111259,
Name = 'Bob',
Phone = 1111111261
WHERE ID = 2555

answered Jul 16 '14 at 15:27

Rahul

76,197
13
71
125

score 1 · Answer 3 · answered Jul 16 '14 at 15:27

1

No. There is no way to do what your query suggests. You are trying to set the same column, ID, to three different values. What is sql supposed to do in this case? You can set multiple columns in the same update statement, but you can't set the same column to three different values.

To update multiple columns, use a comma.

UPDATE  table
SET ID = 111111259,
Name = 'Bob',
Phone = 1111111261
WHERE ID = 2555

answered Jul 16 '14 at 15:27

Vulcronos

3,428
3
16
24

@user3845646 Edited anser. – Vulcronos Jul 16 '14 at 15:33

SQL multi SET with one WHERE

3 Answers3

Linked