Mysql to build data in A table 2 million
Request A table three fields need uniform distribution, the date date in two years time, take 20 zone area, userID20,

CodePudding user response:

2 years, about 730 days, take 20 zone area, userID20, if uniform distribution, then generate the amount of data is 730 * * 200000 to 20,

CodePudding user response:

reference 1st floor AHUA1001 response:

2 years, about 730 days, take 20 zone area, userID20, if uniform distribution, then generate the amount of data is 730 * * 200000 to 20,

no, 2 million data, these a few fields uniformly distributed, it took me several circulation, stupid