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