4.29

造数据啊

所有用到的sql基本都在这了

INSERT INTO `accountnumber_demp05`(`AccountNumber`) SELECT FundAccountNumber FROM `customer_data` 
where
FundAccountNumber is not null  and Age >=65
order by rand()
limit 18

SELECT * FROM `mutual_fund_copy2`
WHERE RiskRating = 'L'
-- 
UPDATE mutual_fund_copy3 SET RiskRating ='H' LIMIT 300

UPDATE mutual_fund_copy4 SET FundCode =NULL
UPDATE mutual_fund_copy5 SET RiskRating ='L'


UPDATE mutual_fund_copy4 SET SandBoxId ='89e1c5e9029543e0824c2f3e4fb5fe5b'


UPDATE mutual_fund_copy5 SET FundPrice =NULL

UPDATE mutual_fund_copy5 SET FundPrice =(select FLOOR(10000000 + (RAND() * 40000001))) LIMIT 2

SELECT * FROM `mutual_fund_copy5`
WHERE RiskRating = "M"



SELECT * FROM `mutual_fund_copy5`
GROUP BY AccountNumber

INSERT INTO `mutual_fund_copy5`(`AccountNumber`) SELECT AccountNumber FROM `accountnumber_demp05` 
order by rand()
limit 18

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