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
Well, first of all, you may want to consider redesigning your two
databases. Most properly designed databases don't have 52 columns in a
table. The process of normalization should decompose these tables further
and make things way less complex. I don't know what the context of your
databases
Unfortunately, I have no option to redesign database A. It's from a third
party. I could potentially redesign database B somewhat, but I think there
would be one table with 30+ columns no matter what.
For instance, I could precisely duplicate the fields from the table in
database A in a table
INTO script and then execute the mysqlimport
command. Crude but ...
Trying to be helpful
- Original Message -
From: Michael J. Kobb [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Monday, April 30, 2001 10:24 PM
Subject: Re: Fundamental (newbie) question
Unfortunately