:[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
mysql COLUMN2=
'[EMAIL PROTECTED
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
mysql COLUMN2=
'[EMAIL PROTECTED]') where COLUMN1='[EMAIL PROTECTED]';
ERROR 1064
, 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...
update TABLE1 a
INNER JOIN TABLE2 b
on a.id = b.other_id
set a.FIELD1=b.FIELD2
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