takovy divny dotaz (vnoreny select) in Mysql

Honza Pazdziora adelton na fi.muni.cz
Středa Leden 23 19:12:47 CET 2002


On Wed, 23 Jan 2002 18:02:14 GMT, Jan Geralt Soc <xsoc na fi.muni.cz> wrote:

> delete from tab1 where id = any (select id from tab2 where (id<>'512') 
> and (sec='4'));
> 
> a toto me na mysql nefunguje, v obou tabulkach je sloupec id jako 
> promarni klic. V literature pisou, ze by to melo fungovat a me to pise 
> syntax error.

Subselecty podporovane nejsou (ve ktere literature to pisi)?
Ve verzich 4.* by melo jit pouzit delete s vice tabulkami.

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
 .project: Perl, mod_perl, DBI, Oracle, auth. WWW servers, XML/XSL, ...
Petition for a Software Patent Free Europe http://petition.eurolinux.org
------------------------------------------------------------------------


Další informace o konferenci Databases