On Monday 05 February 2007 10:07 pm, Rolando Edwards wrote:
Hi Roland:
> Here is something convoluted and sick ...
<grin> convoluted and sick can work. I actually had something
equally convoluted and sick in mind, but was fishing
for a second opinion....
> run 'mysqldump --no-data <database> <table-name>' and redirect to a text
> file. change the table name and column names in the text file as desired
> (using perl) run mysql client redirect input from the text file
>
> Something with more dignity (and no perl)
Perl = no dignity? My biz partner likes perl....
> create table <tbl-new> like <tbl-old>;
> alter table <tbl-new> add column column-2 <definition of column-1> after
> column-1; alter table <tbl-new> drop column column-1;
Wham! I like LIKE!
thanks
tim
> Give a try (the latter one, of course)
>
> ----- Original Message -----
> From: "Tim Johnson" <[EMAIL 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 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 PROTECTED]>
--
Tim Johnson <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
