) ,key
`NewIndex1` ( `FLD_REG_NUM`, `FLD_VERSION_CODE`, `FLD_ADD_DATETIME` ) )
select * from `tbl_version_history`
Rgds
Insane
- Original Message -
From: "David Yee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002 11:40 PM
Subject:
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
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 indexes or those special attributes I mentioned over
