Setting Multiple Variables in SQL in one Query?

Question

I have the following line of code.

UPDATE account 
SET BlockMessage='$BlockMessage', SET BlockAdmin='$AdminUsername', Status=2 
WHERE ID='$ID'

As you can see in trying to set a "BlockMessage, BlockAdmin and Status" in 1 single query. The Infomation is correctly displayed if I echo the 3 individual Variables. however, when running the SQL String it only updates the Block Message row.

Any Ideas?

That statement is invalid SQL. SET may only be used once in an UPDATE statement. — user330315
– user330315, Commented May 12, 2017 at 12:03

Arion · Accepted Answer · 2017-05-12 12:03:47Z

1

You have an extra SET. Update should be something like this:

UPDATE account 
SET 
  BlockMessage='$BlockMessage', 
  BlockAdmin='$AdminUsername', 
  Status=2 
WHERE ID='$ID'

answered May 12, 2017 at 12:03

Arion

31.3k10 gold badges74 silver badges89 bronze badges

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

Comments

Rahul · Accepted Answer · 2017-05-12 12:06:52Z

0

You need use the keyword SET only once like

SET BlockMessage='$BlockMessage', 
BlockAdmin='$AdminUsername', 
Status=2

answered May 12, 2017 at 12:06

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Collectives™ on Stack Overflow

Setting Multiple Variables in SQL in one Query?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related