Skip to content

This is the easiest MySQL random test data generator tool. Load the procedure and execute to auto detect column types and load data.

License

Notifications You must be signed in to change notification settings

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.

About

This is the easiest MySQL random test data generator tool. Load the procedure and execute to auto detect column types and load data.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •