Repository files navigation

This is the easiest MySQL Random Data Generator tool. Load the procedure and execute to auto detect column types and load data in it.

1. Download random data generator (populate.sql and populate_fk.sql) from website or git.

• http://kedar.nitty-witty.com/blog/generate-random-test-data-for-mysql-using-routines

2. Load it to mysql

mysql -uUSER -p DBNAME < populate.sqlmysql -uUSER -p DBNAME < populate_fk.sql

3. Use:

mysql>use DBNAMEmysql>call populate('sakila','film',100,'N');mysql>call populate_fk('sakila','child_table',100,'N');

• Parameters are:database-name,table-name,number-of-records,debug-mode
• Settingdebug-mode asY will print all the insert statements that are being executed.