Skip to content

Instantly share code, notes, and snippets.

@tot-ra

tot-ra/mass_db_insert

Created December 15, 2015 11:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tot-ra/950ab4df8461e572a550 to your computer and use it in GitHub Desktop.
Save tot-ra/950ab4df8461e572a550 to your computer and use it in GitHub Desktop.
Download ZIP
table_load_test.sql
Raw
mass_db_insert
/* repeat X times to get (table cardinality)^X number of rows in it */
INSERT IGNORE INTO table_to_flood (a,b) SELECT FLOOR(RAND()*100000), UUID() FROM table_to_flood;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment