Home > DeveloperSection > Forums > mysql SET and UPDATE
F Scott Fitzgerald
F Scott Fitzgerald

Total Post:29

Points:203
Posted on    July-09-2013 3:19 AM

 MYSQL MYSQL 
Ratings:


 1 Reply(s)
 978  View(s)
Rate this:
Hi Expert!

I'm trying to replace a column value based off values from other columns, but I keep getting syntax errors. What am I doing wrong? Here's what I've tired:

SELECT * FROM `table` WHERE `id_1` =164 and `id_2` = 6
SET `id_1` = (188|164)
WHERE `id_1` = 164 AND `id_2` = 6 
UPDATE `table`

This gives me a syntax near SET.

SELECT * FROM `table` WHERE `id_1` = 164 AND `id_2` = 6
UPDATE `table`
SET `id_1` = 188
WHERE `id_2` = 6

This gives me an error for everything below UPDATE.

Help? Thanks.


AVADHESH PATEL

Total Post:604

Points:4228
Posted on    July-09-2013 4:42 AM

Hi,


You cann't use the UPDATE and SELECT both within a one query.

Execute the both query separately like this:

SELECT * FROM `table` WHERE `id_1` = 164 AND `id_2` = 6
And then execute:

UPDATE `table`
SET `id_1` = 188
WHERE `id_2` = 6;


Don't want to miss updates? Please click the below button!

Follow MindStick