Can you help!!

I have two databases on one MySql sever and I would like to transfer 
certain information from one databases to another.  I want to transfer, 
record by record, from a particular table, after examining the record.  How 
can I open the two databases at the same time?
The only way I am able to do this is by

1. opening one database -
2. read a record from a particular table -
3. close the database -
4. examine the records -
5. open the other database -
6. save information and close.

7. repeat the process for all the records.

I am worried that this may be in efficient.  It there another I could do it?


Fred Kamwaza


---------------------------------------------------------------------
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