Quickly Creating a Large Amount of Pre-Defined Rows? (Better Detail Inside)

FoxhoundX

Alright,

What I essentially want to have is a database with numbers from '00000001' to '99999999'. Each number would have a seperate row.

Now, I could do a for() loop within PHP, but I'm thinking this would take a rather long time to complete. Is there any way that I can Do this without this?

Thanks.

drew010

i think you would have to loop it and do an insert statement for each number you want to insert.
is there a reason you want all these numbers stored in the database when you can use the [man]rand[/man] function to draw random numbers?

celibate54

would this be something that you'd need to create daily ?

or did you just want to reserve/make rows 1-10,000 first so that you could manipulate each row w/ data/etc?

i just use a for loop for making X # of rows exist
( i did it to reserve the top 50 entries in my membership database for admin )

FoxhoundX

There is a valid reason why I need this -- It's not a matter of picking a random number, but it's quite a long explanation. I just know that it will not work with random numbers (Simply because I need 'logging' features as well).

The only problem with a for loop is that only ~1.5 million rows are inserted before the script timing out. Meaning I have to execute the script ~70 Times in order to get all of the numbers inside.

I was just curious if there was any built in MySQL function to do what I needed. But, If not, I suppose I will have to use For loops and wait it out.

drew010

im not sure of a mysql function to acheive this, but in effect, it would still have to insert just about the same amount of data and would take a while.
if your php script is timing out, just put ini_set("max_execution_time", 0); at the beginning and it will set it to never time out.

BuzzLY

set_time_limit(0) accomplishes the same thing. However, if you have safe_mode enabled, it will have no effect.

I do recommend you do this during low- or no-load times. Your server will practically scream to a halt during the execution of this script.