auto increment 초기화

ALTER TABLE PAC.pa_cms_job2 AUTO_INCREMENT=753; SET @count=753;
UPDATE PAC.pa_cms_job2 t1 SET t1.pcm_idx = @count:=@count+1 WHERE pmj_idx >=240

기본 문법

/auto increse
ALTER TABLE P2S.p2s_bill_stock_backup AUTO_INCREMENT=753; SET @count=0;
UPDATE P2S.p2s_bill_stock_backup t1 SET t1.pbs_idx = @count:=@count+1 /