update domains  a INNER JOIN (select u.compid,u.userid from userinfo  u GROUP BY u.userid ) b  on b.userid=a.comp set a.comp=b.compid;
update mycart  a INNER JOIN (select u.compid,u.userid from userinfo  u GROUP BY u.userid ) b  on b.userid=a.comp set a.comp=b.compid;
update product  a INNER JOIN (select u.compid,u.userid from userinfo  u GROUP BY u.userid ) b  on b.userid=a.comp set a.comp=b.compid;
update userin  a INNER JOIN (select u.compid,u.userid from userinfo  u GROUP BY u.userid ) b  on b.userid=a.comp set a.comp=b.compid

 

SET @i=0;

UPDATE `product` SET `id`=(@i:=@i+1);

ALTER TABLE `product` AUTO_INCREMENT=0

 

insert into product_copy select * from product order by id asc