Subselects are not yet supported in the 4.0 release.
----- Original Message -----
From: "Kyle Hayes" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 4:40 PM
Subject: Re: Features in 4.0
>
> I did not see subselects in this list. Will MySQL support subselects in
4.x?
>
> What exactly does the "LOAD TABLE FROM MASTER" 'automagically' comment
mean?
> Does that command sync the slave with the master at that point? If I
have
> three tables, A, B, and C, and I want to load them at runtime from the
master
> and start replication do I have to lock them before doing "LOAD TABLE FROM
> MASTER"?
>
> We are searching for a solution to enable us to load a large amount of
data
> without stopping the master for more than a couple of seconds. So far, we
> have been able to write our own complex code to do this, but it is far
from
> the level of automation that we want.
>
> Could someone from the MySQL team please give us some details on
subselects
> and the new load table functionality?
>
> Best,
> Kyle
>
> On Tuesday 25 September 2001 14:29, Fournier Jocelyn [Presence-PC] wrote:
> > Take a look at this :)
> >
> > http://www.mysql.com/doc/N/e/News-4.0.0.html
> >
> > I'm currently using MySQL 4.0 on two servers, and it works great :)
> > Union seems also to work really fine now although it remains some
features
> > to be added before beeing perfect.
> >
> > Jocelyn Fournier
> > Presence-PC
>
> --
> Quicknet has just released the following new products:
> Internet SwitchBoard v5.5 and MicroTelco Gateway 2.0. We
> have also added a new low cost carrier, Blue Star Telecom
> to our award winning MicroTelco services. For more
> information visit: www.quicknet.net or www.microtelco.com
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php