Re: Create new table and insert other table data

[Ramalingam Chelliah]

Hi RootChaos ( Name ?)(Are you called so) ,

If you like to add an AUTO_INCREMENTing field say IDA to tbl_200410
after creating other fields ,
( Remember that AUTO_INCREMENTing field must be the primary key)

Assumin you have created 'tbl_200410' from 'master'

mysql>ALTER TABLE tbl_2004
ADD COLUMN IDA INTEGER NOT NULL AUTO_INCREMENT,
ADD CONSTRAINT PRIMARY KEY(IDA) ;

I will let you know if there is some other way...

Hope this helps .....

Regards,
Ram.



We Learn the Most When we have to Invent