gt; that passes mysql the SELECT 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]>
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 i
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 a