Generate random test data for MySQL using routines

Generate random test data for MySQL using routines Files Download the sql code: populate_dummy_data.sql. Download sql for generating random data for foreign-key dependent child tables: populate_fk.sql Install mysql -uUSER -pPASSWORD DATABASE_NAME < populate_dummy_data.sql mysql -uUSER -pPASSWORD DATABASE_NAME < populate_fk.sql Usage Run this SQL query call populate(‘DATABASE-NAME’,’TABLE-NAME’,NUMBER-OF-ROWS,DEBUG-MODE); DEBUG-MODE (‘Y’,’N’) will print an SQL that’s executed and… continue reading