Re: Cloning a table with different column names

2007-02-05 Thread Tim Johnson
On Monday 05 February 2007 10:07 pm, Rolando Edwards wrote: Hi Roland: > Here is something convoluted and sick ... convoluted and sick can work. I actually had something equally convoluted and sick in mind, but was fishing for a second opinion > run 'mysqldu

Re: Cloning a table with different column names

2007-02-05 Thread Rolando Edwards
Here is something convoluted and sick ... run 'mysqldump --no-data ' 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) create table like ; alt