thanks
thought there was something simpler
Jay Blanchard wrote:
[snip]
We've got a local system (PHP intranet) and we need to connect to a live
mySQL server get some of the tables (contents) and overwrite the same
tables in the local mySQL database. This needs to be done with PHP.
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
