Filling a table with info for testing
Moderator: General Moderators
Filling a table with info for testing
I want to fill one of my database tables with a bunch of info(junk/anything) to test the search speeds when there are several thousand entries. is there some sort of dynamic insert loop I can use?
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Code: Select all
for ($x = 0; $x < 10000; $x++;) {
mysql_query('INSERT INTO `table` SET `column1` = \'jdsfhsdhfjashfkshdffsdf\'') or die(mysql_error());
}