How to create or generate sample / test data (mass data for tables) ?
Hello,
I'm playing around a little with some SQL-functions, but actually I have only a small number of rows in my sample table and I would like to have "big, filled tables". :-)
Is there an easy way to generate mass data for tables, e.g. for testing the performance of SQL-statements when a table is full of data.
For example:
How can I generate lets say 50.000 or 100.000 rows into a table with two columns? Is there a ready-to-use command to generate this mass of data?
How do you create random data for testing?
Thanks a lot in advance for your help!
Best regards
FireFighter