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. Link to comment https://forums.phpfreaks.com/topic/65097-desktop-sql-editor/ 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? Link to comment https://forums.phpfreaks.com/topic/65097-desktop-sql-editor/#findComment-324885 Share on other sites More sharing options...
fenway Posted August 21, 2007 Share Posted August 21, 2007 Blank rows? Link to comment https://forums.phpfreaks.com/topic/65097-desktop-sql-editor/#findComment-330167 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. Link to comment https://forums.phpfreaks.com/topic/65097-desktop-sql-editor/#findComment-330173 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.