ng Tan Son'" <[EMAIL PROTECTED]>
Sent: Thursday, March 16, 2006 10:51 PM
Subject: RE: Error 1064: update .select nested.
AAAUUUGGGHHH!!! You used the dreaded "comma separated list" !!! ;-)
A more explicit way to write the same thing posted by Sr. Cruz...
upd
ECTED]'
>
>
> Regards!
>
> -Mensaje original-
> De: Truong Tan Son [mailto:[EMAIL PROTECTED]
> Enviado el: Miércoles, 15 de Marzo de 2006 07:22 p.m.
> Para: mysql@lists.mysql.com
> Asunto: Error 1064: update .select nested.
>
>
> Dear Sir,
---
De: Truong Tan Son [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 15 de Marzo de 2006 07:22 p.m.
Para: mysql@lists.mysql.com
Asunto: Error 1064: update .select nested.
Dear Sir,
MySQL-4.1.12 on RedHat Linux EL4:
mysql> update TABLE1 set FIELD1=(select FIELD2 from TABLE2 where
Dear Sir,
MySQL-4.1.12 on RedHat Linux EL4:
mysql> update TABLE1 set FIELD1=(select FIELD2 from TABLE2 where COLUMN2=
'[EMAIL PROTECTED]') where COLUMN1='[EMAIL PROTECTED]';
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for t
