insert into player_equipment (id,player_id,equipment_id,equipment_num)
select @i:=@i+1 as id, t.* from
(select 1,t.id,100 from s_car_equipment t) t ,(SELECT @i :=(select ifnull(max(a.id),0) from player_equipment a)) r;
mysql insert_select ID 自增长
最新推荐文章于 2024-07-26 03:37:57 发布