MySQL rename and indexes

[Alex Dean]

On Nov 3, 2006, at 6:35 PM, der.hans wrote:

>> Any tips on creating a new table and indexes based on another  
>> table and
>> its indexes?

To create a new table based on an existing one, you can to this :  
"CREATE TABLE new_table LIKE old_table"

This is just the column and index information.  If you also want the  
data, next do : "INSERT INTO new_table SELECT * FROM old_table"

regards,
alex
.