I have a table tbl_version_history which has a primary key and an index.
Through this query I am able to create a copy tbl_version_history_copy with
all the index.
Just replace the stuff with yours and probably it will help.
create table `tbl_version_history_copy` ( primary key ( FLD_REG_NUM )
At 11:10 -0700 10/15/02, David Yee wrote:
>Hi all. What's the quickest way to copy a table so that all column
>attributes such as auto_increment and primary key along with all indexes get
>copied over? I like using:
>
>create table new_table select * from old_table
>
>But it doesn't copy any ind
