mysql 查询数据 select 自动增长 id,增加自动增长虚列
insert into fin_subject_count (UID,subject_id,subject_count_type,balance,object_id,state,gmt_create,gmt_modified)
select
(SELECT   count(*)   as   dd   FROM   bas_business_unit as   a   where   a.unit_uid<b.unit_uid)+1000 as newUid
,
(SELECT   count(*)   as   dd   FROM   bas_business_unit as   a   where   a.unit_uid<b.unit_uid)+1000 as subject_id
,1,0,b.unit_uid,1,now(),now() from bas_business_unit as b