Comments by deepika.tella (Top 4 by date)

this table (locatorcheckout) has been partitioned

I am using Alter command....Like
ALTER TABLE `scltms_test`.`locatorcheckout` DROP COLUMN `CheckoutStatusid` , ADD COLUMN `CheckoutStatusid` INT(11) NOT NULL AFTER `CheckOutDate` ,
ADD CONSTRAINT `fk_locatorcheckout_checkoutstatus1`
FOREIGN KEY (`CheckoutStatusid` )
REFERENCES `scltms_test`.`checkoutstatus` (`CheckoutStatusid` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_locatorcheckout_users1`
FOREIGN KEY (`LocatorId` )
REFERENCES `scltms_test`.`users` (`Usersid` )
ON DELETE NO ACTION
ON UPDATE NO ACTION
, DROP PRIMARY KEY
, ADD PRIMARY KEY (`locatorcheckoutid`, `LocatorId`, `CheckoutStatusid`)
, DROP PRIMARY KEY
, ADD PRIMARY KEY (`locatorcheckoutid`, `LocatorId`, `CheckoutStatusid`)
, DROP INDEX `indx_Locchkoutdt`
, ADD INDEX `indx_Locchkoutdt` USING BTREE (`CheckOutDate` ASC)
, DROP INDEX `fk_locatorcheckout_checkoutstatus1`
, ADD INDEX `fk_locatorcheckout_checkoutstatus1` (`CheckoutStatusid` ASC) ;

The Above code is the one of the tables... above script was generated from reverse Engineer(EER Diagram).

Try this....
insert into table2(column1) select column2 from table1;