I have somewhere around 30 tables used in my web application. I need to populate those tables with some dummy values during development. Later once the application is ready we will have the real data. Are there any tools to populate database tables in MySQL with dummy values?
我的web应用程序中大约有30个表。在开发期间，我需要用一些假值填充这些表。在应用程序准备好之后，我们将获得真实的数据。有没有工具可以用假值填充MySQL中的数据库表?
3 个解决方案
#1
4
You could try this:
你可以试试这个:
http://www.generatedata.com/
I've been meaning to look at it for a while, but never quite got round to it.
我一直想看一看，但还没来得及看。
#2
0
you could use SQLyog to easily manage your database. The community edition is free.
您可以使用SQLyog轻松地管理数据库。社区版是免费的。
#3
0
With Jailer you can export data to an SQL script which can traverse foreign key constraints to include all data needed to maintain referential integrity.
通过使用Jailer，您可以将数据导出到一个SQL脚本中，该脚本可以遍历外键约束，以包含维护引用完整性所需的所有数据。
Here is a screenshot from the Jailer website demonstrating the data export:
以下是来自Jailer网站的截图，展示了数据输出:
Jailer export http://jailer.sourceforge.net/qt5.gif
狱卒出口http://jailer.sourceforge.net/qt5.gif
#1
4
You could try this:
你可以试试这个:
http://www.generatedata.com/
I've been meaning to look at it for a while, but never quite got round to it.
我一直想看一看，但还没来得及看。
#2
0
you could use SQLyog to easily manage your database. The community edition is free.
您可以使用SQLyog轻松地管理数据库。社区版是免费的。
#3
0
With Jailer you can export data to an SQL script which can traverse foreign key constraints to include all data needed to maintain referential integrity.
通过使用Jailer，您可以将数据导出到一个SQL脚本中，该脚本可以遍历外键约束，以包含维护引用完整性所需的所有数据。
Here is a screenshot from the Jailer website demonstrating the data export:
以下是来自Jailer网站的截图，展示了数据输出:
Jailer export http://jailer.sourceforge.net/qt5.gif
狱卒出口http://jailer.sourceforge.net/qt5.gif