mysql一张表id重新录入，另一张表的id也跟着改变

去除auto increament
ALTER TABLE `sy_yuyue` DROP PRIMARY KEY

alter table sy_yuyue order by id

delimiter //
drop procedure if exists sp3//
# MySQL 返回的查询结果为空 (即零行)。

create procedure sp3(IN param2 INT,OUT param1 INT)
 begin
     SELECT id into param1 FROM `sy_yuyue` where id >param2 and id<4245 limit 1;
 end//
# MySQL 返回的查询结果为空 (即零行)。
delimiter ;



delimiter //

drop procedure if exists wk//

CREATE DEFINER=`root`@`localhost` PROCEDURE `wk`()
begin
     declare i ,s ,n int;
     set i=4245;
     set s=0;
     set n=1;
     while n <= 50 do
     call sp3(s,@a);
     update sy_yuyue set id=i where id=@a;
     update sy_remark set yuyueId=i where yuyueId=@a;
     set i = i +1;
     set n = n+1;
     set s=@a;
     end while;
end//
delimiter ;

call wk();

重置remarkId

alter table sy_remark AUTO_INCREMENT=1;