MySQL Forums
Forum List  »  MySQL Query Browser

Advanced Search
New Topic

delete with mysql 4.1.9
Posted by: alioune ould zekeria
Date: October 05, 2005 08:36AM

Hi all
Please help,
I am trying to execute:

DELETE
FROM T_DOUBLON as T
WHERE T.COLID < ANY ( SELECT COLID
FROM T_DOUBLON as T2
WHERE T.COLID <> T2.COLID
AND T.NUM = T2.NUM
AND T.NOM = T2.NOM
AND T.PRENOM = T2.PRENOM)

I am using MySQL 4.1.9 and got error like syntaxe error next...

any ideas?
thanks

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
delete with mysql 4.1.9
alioune ould zekeria
October 05, 2005 08:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.