Please forgive the relatively basic nature of this question. I'm new at
this. I have the DuBois MySQL book and the O'Reilly one as well, so please
feel free to point me at a page number. I couldn't find the answer myself.
I have two databases. Database A has a few tables, and the table of
interest has about 35 columns.
Database B also has a few tables, and one of them has about 52 columns. 35
of those 52 are exactly the same as the ones in the table in Database A.
One could think of the data in Database B almost as a C++ subclass of the
data in Database A -- it has all the same fields, plus some extra ones.
Is there a relatively easy way to take a record in Database A and copy all
the matching fields over to a record in Database B?
I wish I could post the exact tables and such, but I can't. Here's a
simplified version:
Database A, table 1 has:
Name
Address
Phone
Birthday
Database B, table 1 has:
Name
Address
Phone
Birthday
Purchases
Account balance
I would like to be able to easily make a new record in database B, copying
over the data from the matching fields in A.
Before you suggest that B should simply point at A, I can't do that
unfortunately. The data in A "ages out" over time, but the data in B needs
to persist. So, I think the best choice is to copy.
Thanks!
--Mike
---------------------------------------------------------------------
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
