Any freeware or open source tool to populate database with some dummy values

I have somewhere around 30 tables used in my web application. I开发者_如何学C 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?

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.

you could use SQLyog to easily manage your database. The community edition is free.

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.

Here is a screenshot from the Jailer website demonstrating the data export:

I'm 10 years late, but I created a tool that handles the creation of tables and populate them with fake (but valid) data. Maybe it was not exactly what you wanted but if anyone is interested you may give it a try.