avillanu Posted August 15, 2007 Share Posted August 15, 2007 I need to create a table of 2000+ blank rows. I tried doing it with a simple WHILE loop and INSERT line but only got to about 500 entries before timing out. I'm hoping that there's some MySQL desktop program that I could use to create a file that I could simply import. If you have any other suggestions it would be greatly appreciated. Quote Link to comment Share on other sites More sharing options...
avillanu Posted August 15, 2007 Author Share Posted August 15, 2007 Interesting...I've done a little research and it seems that I could simply create an excel file with the values I want. So I'm thinking: Use a simple PHP file to create the database column attributes I would like (mediumint, autoincrement and such) and then import an excel file. Would this work? Any drawbacks? Quote Link to comment Share on other sites More sharing options...
fenway Posted August 21, 2007 Share Posted August 21, 2007 Blank rows? Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted August 21, 2007 Share Posted August 21, 2007 If you have shell access you could run the script from the command line, then it can't timeout. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.