moving records over from a dissimilar table

[sfullman]

I'm running mySQL 3.23.53 I think, fairly recent.

I have table A which has a set of fields. Table B has all of the fields that table A has (by the same name and type exactly), and then some more. Plus, table B's common fields with A are not in the same order.

Is there a quick command to insert records from table A into B, providing only the records they have in common.

P.S. If there isn't I can write a script to do this and share it on the forum but I don't want to reinvent the wheel.

Thanks very much,
Sam Fullman
Compass Point Media

[ultraslacker]

INSERT INTO B SELECT {COLUMNS in order of B, plus defaults or nulls for missing columns) FROM A

-or-

INSERT INTO B {COLUMNS} SELECT {COLUMNS} FROM A

If a column in B is not null, then it will require a default or a value specified in the SELECT.

[sfullman]

kinda thought that you had to spell it out, ultra, I posted a script on here for that purpose, makes it easy to name two tables and the rest is done automatically.

Sam