All pastes #2072410 Raw Edit

Mine

public sql v1 · immutable
#2072410 ·published 2011-05-30 18:07 UTC
rendered paste body
ALTER TABLE tblcustomers AUTO_INCREMENT = 2000;ALTER TABLE `tollring_crm`.`tblcustomers` CHANGE COLUMN `customerid` `customerid` INT(11) NOT NULL AUTO_INCREMENT  ;Error Code: 1062ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY'