Cloning a table with different column names

Hello: I have a need to create two tables from imported data. The only difference between the tables is the column names. The data will be the same. Can anyone propose a mysql method to create a new table from an existing table with new column names? thanks tim -- Tim Johnson [EMAIL

Re: Cloning a table with different column names

@lists.mysql.com Sent: Tuesday, February 6, 2007 7:15:12 AM (GMT-0500) US/Eastern Subject: Cloning a table with different column names Hello: I have a need to create two tables from imported data. The only difference between the tables is the column names. The data will be the same. Can anyone

Re: Cloning a table with different column names

PROTECTED] To: MySQL General Mailing List mysql@lists.mysql.com Sent: Tuesday, February 6, 2007 7:15:12 AM (GMT-0500) US/Eastern Subject: Cloning a table with different column names Hello: I have a need to create two tables from imported data. The only difference between the tables is the column