Skip to content

kedarvj/mysql-random-data-generator

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

29 Commits
 
 
 
 
 
 
 
 

Repository files navigation

mysql-random-data-generator

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

Usage:

  1. Download random data generator (populate.sql and populate_fk.sql) from website or git.
  1. Load it to mysql
mysql -uUSER -p DBNAME < populate.sql
mysql -uUSER -p DBNAME < populate_fk.sql
  1. Use:
mysql>use DBNAME

mysql>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
  • Setting debug-mode as Y will print all the insert statements that are being executed.