use assets_core;
begin;
INSERT INTO assets_core.ac_asset_bb_centre
select CEILING(RAND()*8888888888888+88888888888888888), ‘2‘, c.fuser_id ,
‘BTC‘,‘10.000000000000000000000000000000‘,‘0.000000000000000000000000000000‘,‘1‘
from counter.uc_user_detail c inner join authc_core.uc_user_core a on a.fid=c.fuser_id
where c.fkyc2 =‘3‘
and c.fkyc2_create>=‘2018-12-17 11:00:00‘
and c.fkyc2_create<=‘2018-12-28 12:00:00‘
and c.fuser_id not in (select user_id from mypro.pro_act_user_id);
INSERT INTO assets_core.ac_asset_bb_centre
select CEILING(RAND()*8888888888888+88888888888888888), ‘2‘, c.fuser_id ,
‘ETH‘,‘100.000000000000000000000000000000‘,‘0.000000000000000000000000000000‘,‘1‘
from counter.uc_user_detail c inner join authc_core.uc_user_core a on a.fid=c.fuser_id
where c.fkyc2 =‘3‘
and c.fkyc2_create>=‘2018-12-17 11:00:00‘
and c.fkyc2_create<=‘2018-12-28 12:00:00‘
and c.fuser_id not in (select user_id from mypro.pro_act_user_id);
INSERT INTO assets_core.ac_asset_bb_centre
select CEILING(RAND()*8888888888888+88888888888888888), ‘2‘, c.fuser_id ,
‘USDT‘,‘1000.000000000000000000000000000000‘,‘0.000000000000000000000000000000‘,‘1‘
from counter.uc_user_detail c inner join authc_core.uc_user_core a on a.fid=c.fuser_id
where c.fkyc2 =‘3‘
and c.fkyc2_create>=‘2018-12-17 11:00:00‘
and c.fkyc2_create<=‘2018-12-28 12:00:00‘
and c.fuser_id not in (select user_id from mypro.pro_act_user_id);
INSERT INTO assets_core.ac_asset_bb_centre
select CEILING(RAND()*8888888888888+88888888888888888), ‘2‘, c.fuser_id ,
‘OMG‘,‘10000.000000000000000000000000000000‘,‘0.000000000000000000000000000000‘,‘1‘
from counter.uc_user_detail c inner join authc_core.uc_user_core a on a.fid=c.fuser_id
where c.fkyc2 =‘3‘
and c.fkyc2_create>=‘2018-12-17 11:00:00‘
and c.fkyc2_create<=‘2018-12-28 12:00:00‘
and c.fuser_id not in (select user_id from mypro.pro_act_user_id);
INSERT INTO assets_core.ac_asset_bb_centre
select CEILING(RAND()*8888888888888+88888888888888888), ‘2‘, c.fuser_id ,
‘TRX‘,‘100000.000000000000000000000000000000‘,‘0.000000000000000000000000000000‘,‘1‘
from counter.uc_user_detail c inner join authc_core.uc_user_core a on a.fid=c.fuser_id
where c.fkyc2 =‘3‘
and c.fkyc2_create>=‘2018-12-17 11:00:00‘
and c.fkyc2_create<=‘2018-12-28 12:00:00‘
and c.fuser_id not in (select user_id from mypro.pro_act_user_id);
INSERT INTO assets_core.ac_asset_bb_centre
select CEILING(RAND()*8888888888888+88888888888888888), ‘2‘, c.fuser_id ,
‘RNT‘,‘100000.000000000000000000000000000000‘,‘0.000000000000000000000000000000‘,‘1‘
from counter.uc_user_detail c inner join authc_core.uc_user_core a on a.fid=c.fuser_id
where c.fkyc2 =‘3‘
and c.fkyc2_create>=‘2018-12-17 11:00:00‘
and c.fkyc2_create<=‘2018-12-28 12:00:00‘
and c.fuser_id not in (select user_id from mypro.pro_act_user_id);
INSERT INTO `assets_core`.`ac_asset_change_bb_centre`
(`fid`, `fassert_id`, `fcounter_id`, `fuser_id`, `fcoin_id`, `fcount`, `ftype`, `fside`,
`ftime`, `flabel`, `fee`, `fstate`, `flock_count`, `fasset_change_id`)
select distinct CEILING(RAND()*8888888888888+88888888888888888), d.fid , ‘2‘, c.fuser_id, d.fcoin_id, d.fcount,
‘2018-12-14 kyc2-1 activity‘, 0, now(), ‘空投资产‘, 0.000000000000000000000000000000, ‘1‘, 0, NULL
from counter.uc_user_detail c inner join authc_core.uc_user_core a on a.fid=c.fuser_id
inner join assets_core.ac_asset_bb_centre d on c.fuser_id=d.fuser_id
where c.fkyc2 =‘3‘
and c.fkyc2_create>=‘2018-12-17 11:00:00‘
and c.fkyc2_create<=‘2018-12-28 12:00:00‘
and c.fuser_id not in (select user_id from mypro.pro_act_user_id);
insert into mypro.pro_act_user_id (user_id)
select c.fuser_id
from counter.uc_user_detail c inner join authc_core.uc_user_core a on a.fid=c.fuser_id
where c.fkyc2 =‘3‘
and c.fkyc2_create>=‘2018-12-17 11:00:00‘
and c.fkyc2_create<=‘2018-12-28 12:00:00‘
and c.fuser_id not in (select user_id from mypro.pro_act_user_id);
commit;
原文：https://www.cnblogs.com/liang545621/p/10134484.html