SQL - work around

samatair

Expand|Select|Wrap|Line Numbers

 UPDATE users set user_type='CLIENT' where user_id in (SELECT user_id FROM clients)
 

The above query is not working with MYSQL version 4.xx, is there a work around for this.

Atli

You could try an INNER JOIN.

Like:

Expand|Select|Wrap|Line Numbers

 
UPDATE userTable AS u

INNER JOIN clientTable AS c

    ON u.ID = c.ID

SET u.UserType = 'Client';

samatair

Thank you Atli. But it also gives
Error:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mwasif

Try this one

Expand|Select|Wrap|Line Numbers

 UPDATE users, clients SET users.user_type='CLIENT' 

WHERE users.user_id = clients.user_id

Atli

Quote:

Originally Posted by samatair

Thank you Atli. But it also gives
Error:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Weird. It worked for me.
I didn't use the same names as you did tho, so make sure you didn't accidentally mess up the syntax when you edited it. (Assuming you did actually edit it?)

The query mwasif posted should work to tho, and he uses that same names you did.
Try that and see what happens.

samatair

Great! mwasif's query worked fine. Thank you very much.
Thank you too Atli for the follow up and suggestions.
You both were so helpful.

Thanks once again!

SQL - work around

re: SQL - work around

re: SQL - work around

re: SQL - work around

re: SQL - work around

re: SQL - work around

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about