INSERT ignore INTO sys_org(`username`,`area_code`,`status`,`org_level`,`org_type`,`welfare_org`,`name`,`address`,`coordinate_address`,`qr_code`,`concat`,`mobile`,`recruit_disabled_status`,`delete_status`)
SELECT ( SELECT (@i:=@i+1)+username AS u FROM sys_org username ORDER BY CONVERT(username, SIGNED) DESC LIMIT 1) a, area_code,2,4,28,0,`name`,address,coordinate_address,0,phone,mobile,1,0 FROM (bus_barrier_free_facilities,(SELECT @i:=1) t0) WHERE area_code LIKE '330521%';
不同表的数据查询出来的数据进行插入
最新推荐文章于 2023-03-23 08:26:09 发布