4.28

——————————————关于accountnumber的生成—————————————————————————

将从customer_data表中查询出来 年龄在25-34之间的客户的accountnumber随机取出168条    插入到一张临时表accountnumber_demp00中

INSERT INTO `accountnumber_demp00`(`AccountNumber`) SELECT FundAccountNumber FROM `customer_data` 
where
FundAccountNumber is not null  and Age between 25 and 34 
order by rand()
limit 168

从临时表accountnumber_demp00中  再次插入上面取出的168条账户信息，以至于达到要求的2-4倍（其实现在是两倍）

INSERT INTO `accountnumber_demp00`(`AccountNumber`) SELECT AccountNumber FROM `accountnumber_demp00` 
order by rand()
limit 168

然后在随机取100个 （感觉取不取无所谓） 再插进去

INSERT INTO `accountnumber_demp00`(`AccountNumber`) SELECT AccountNumber FROM `accountnumber_demp00` 
order by rand()
limit 100

 

——————————————————————————————————————————————————————————————————————————————————————————————————————————————————

 

更新表的ID 设置为uuid(不重复的)

UPDATE mutual_fund_copy1 set ID =( SELECT MD5(uuid()) );

更新表的AccountNumber时，直接cv 上一段已经写好的。

更新表的RiskRating

UPDATE mutual_fund_copy1 SET RiskRating ='H' LIMIT 174

更新表的TradingAmount，可以先把随机数放到 TrdingCommission这个没用的字段上，然后复制

UPDATE mutual_fund_copy1 SET TrdingCommission =(select FLOOR(10000000 + (RAND() * 40000001))) LIMIT 17