Could you just write a simple script to programmatically randomly generate the required data? I would use python, but you could do it in practically anything.
Something along the lines of this pseudo code should do the trick:
for i in range(0, 100000):
name = randomName()
email = randomEmail()
insertIntoSomeTable(name, email)
Where randomName generates a random name, randomEmail generates a random email and insertIntoSomeTable takes the randomly generated data and inserts it into one of your tables. These functions should be trivial to implement.
Repeat for all of the tables you need random data for.
发布评论
评论（2）
该网站为您提供大量用于测试目的的免费数据：www.fakenamegenerator.com
This website offers you a lot of free data for tests purpose : www.fakenamegenerator.com
您可以编写一个简单的脚本来以编程方式随机生成所需的数据吗？我会使用 python，但你几乎可以在任何东西中做到这一点。
沿着此伪代码的某些内容应该可以解决问题：
其中
randomName生成随机名称，randomEmail生成随机电子邮件，insertIntoSomeTable获取随机生成的数据并将其插入到您的表之一中。这些功能的实现应该很简单。对您需要随机数据的所有表重复此操作。
Could you just write a simple script to programmatically randomly generate the required data? I would use python, but you could do it in practically anything.
Something along the lines of this pseudo code should do the trick:
Where
randomNamegenerates a random name,randomEmailgenerates a random email andinsertIntoSomeTabletakes the randomly generated data and inserts it into one of your tables. These functions should be trivial to implement.Repeat for all of the tables you need random data for.