Hi Jay
Thanks again, Now how would I do the
SELECT remote_stuff INTO local_table; ?
as these are on two different MySQL connections?
Im not sure if this is possible to do in one statement or query? Seems possible in theory but I'm not sure.
original message:
Im wondering the best to do this.
Is it to get all the information into result sets for each table and
then delete the contents of each local table and then looping through
the result sets just insert the information into the local tables? This
seems like a good solution but I wonder if there are any out there
before going ahead with development.
[/snip]
TRUNCATE local_table;
SELECT remote_stuff INTO local_table;
--
------------------------------------------------------------------------
Angelo Zanetti
Systems developer
------------------------------------------------------------------------
*Telephone:* +27 (021) 552 9799
*Mobile:* +27 (0) 72 441 3355
*Fax:* +27 (0) 86 681 5885
*
Web:* http://www.zlogic.co.za
*E-Mail:* angelo@xxxxxxxxxxxx <mailto:angelo@xxxxxxxxxxxx>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
