This is the easiest MySQL random test data generator tool. Load the procedure and execute to auto detect column types and load data.
This is the easiest MySQL Random Data Generator tool. Load the procedure and execute to auto detect column types and load data in it.
mysql -uUSER -p DBNAME < populate.sql
mysql -uUSER -p DBNAME < populate_fk.sql
mysql>use DBNAME
mysql>call populate('sakila','film',100,'N');
mysql>call populate_fk('sakila','child_table',100,'N');
database-name
, table-name
, number-of-records
, debug-mode
debug-mode
as Y
will print all the insert statements that are being executed.