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

Reply via email to