4.27

造数据：

1.查询出年龄在18-24岁的45条数据插入到另一张表中

SELECT StockAccountNumber,age FROM `customer_data` 
where
StockAccountNumber is not null  and Age between 18 and 24 
order by rand()

SELECT FLOOR( 1 + RAND() * (3)生成随机的1-3条数据

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------

好家伙，又给我换了张表，第一张说是太难了

先查出来FundAccountNumber

SELECT * FROM `mutual_fund`
where
AccountNumber in(
SELECT FundAccountNumber FROM `customer_data` 
where
FundAccountNumber is not null  and Age between 18 and 24 
)
order by AccountNumber

 再插入到新表中

INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('4b5f8f9b3d254841b14af06d61214b7a', 'HK', '128', '176', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK14128835003286965500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('d6bdb6f1a1694e73b8c5aff6cc0a9553', 'HK', '128', '176', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK14128835003286965500', 'Sell');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('425f279e929b4339a53c108495a1b2db', 'HK', '128', '176', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK14128835003286965500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('5dac882a6c9e4a84b6e3e6a40131b6e1', 'HK', '128', '149', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK18128843003286904500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`,`AccountNumber`, `TradingOption`) VALUES ('9d90b9e5fd094065a8826cf5464768d2', 'HK', '128', '149', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK18128843003286904500', 'Sell');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('4b329839660f43ff983449523134528d', 'HK', '128', '143', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK20128832003280836500', 'Sell');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('69dc77fea998420ba79a4f2a0ec9e603', 'HK', '128', '143', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK20128832003280836500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('c86c2a7f16d142f7926d72b631bb3daa', 'HK', '128', '110', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK38128843003289705500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`,  `AccountNumber`, `TradingOption`) VALUES ('748eb434fc304377a856c6e0a56bbcb2', 'HK', '128', '113', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK48128836003287803500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('2424528de3bc4c92bba0c928894e3242', 'HK', '128', '113', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK48128836003287803500', 'Sell');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('3e5a1e06987d411ab78418f3ad19df5a', 'HK', '128', '113', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK48128836003287803500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`,  `AccountNumber`, `TradingOption`) VALUES ('44cbf16af00942288d1cee382017e0bb', 'HK', '128', '175', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK54128844003279651500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`,`AccountNumber`, `TradingOption`) VALUES ('7276bbee3cb34e42b8ce6b0f8f16b75a', 'HK', '128', '175', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK54128844003279651500', 'Sell');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('13b5d77e81f34320ad3d5d450084a4ac', 'HK', '128', '161', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK55128842003282221500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('5bbae21425ac47569a3cd3bc1b970a9e', 'HK', '128', '172', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK56128835003285155500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('86c438a6e5754911b7c789e422e11dfb', 'HK', '128', '172', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK56128835003285155500', 'Sell');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('32d36c8641a3489c96728a214152b59f', 'HK', '128', '172', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK56128835003285155500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('8b25dacc1e5d472080666e77799a28f7', 'HK', '128', '137', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK65128836003290470500', 'Sell');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`,`AccountNumber`, `TradingOption`) VALUES ('09f1817fe3b3491193b4f82d061dd46d', 'HK', '128', '137', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK65128836003290470500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`,`AccountNumber`, `TradingOption`) VALUES ('95580408f9ec4e369c27c131ae0cd29a', 'HK', '128', '143', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK69128833003289716500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('59724ceeb9924c15a32b4273d3d756a9', 'HK', '128', '130', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK72128846003288341500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('9c2d33efcf6c499e971c28675c906d90', 'HK', '128', '162', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK79128836003285922500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('79bad082ea814d3e91510d37681ea931', 'HK', '128', '169', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK79128849003282958500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('dd02b3b3c7994ddb926859427a20788f', 'HK', '128', '169', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK79128849003282958500', 'Sell');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('879782903b7346dd8dc5f4164b95916e', 'HK', '128', '166', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK84128839003279124500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('0406f6b06cdc4cfc800eed43bf16e5ce', 'HK', '128', '166', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK84128839003279124500', 'Sell');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('461ed2673da14d84a6eaa679f9ad4c3b', 'HK', '128', '137', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK85128836003282019500', 'Sell');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('9687f4db93674f20865bdf2c053a11cc', 'HK', '128', '137', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK85128836003282019500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`,  `AccountNumber`, `TradingOption`) VALUES ('8f0a04a8a15f41748d957fab9664b61a', 'HK', '128', '147', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK98128836003294272500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('f36ef9c5683642069067037032382c67', 'HK', '128', '147', '89e1c5e9029543e0824c2f3e4fb5fe5b',  'HK98128836003294272500', 'Sell');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('68a8bfb296ac48ac81f426e1ffc48632', 'HK', '128', '171', '89e1c5e9029543e0824c2f3e4fb5fe5b',  'HK98128844003277510500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`, `AccountNumber`, `TradingOption`) VALUES ('d983a49c6a89439b91af64350673b42b', 'HK', '128', '171', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK98128844003277510500', 'Buy');
INSERT INTO `mutual_fund_copy1`(`ID`, `CountryCode`, `ClearingCode`, `BranchCode`, `SandBoxId`,  `AccountNumber`, `TradingOption`) VALUES ('b9a028e4f33542a28def238c289845cd', 'HK', '128', '171', '89e1c5e9029543e0824c2f3e4fb5fe5b', 'HK98128844003277510500', 'Buy');

 

UPDATE mutual_fund_copy1 SET TradingAmount =FLOOR(10000 + (RAND() * 40001)) ;

select FLOOR(500000 + (RAND() * 500001))