galvin Posted January 31, 2010 Share Posted January 31, 2010 Can someone tell me how to write a SQL query to INSERT 2,500 blank records into a mySql database? The only field is "boxid" and I have it set to auto-increment, so I think they will get numbered 1, 2,3,4 etc, etc all the way up to 2,500 (which is what I want), but I'm unsure if/how I can insert 2,500 records at once. Anyone know? FYI, the table name is "boxes" Quote Link to comment https://forums.phpfreaks.com/topic/190411-insert-2500-records-into-mysql/ Share on other sites More sharing options...
galvin Posted January 31, 2010 Author Share Posted January 31, 2010 Hey, I figured something out for myself!! Quote Link to comment https://forums.phpfreaks.com/topic/190411-insert-2500-records-into-mysql/#findComment-1004446 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.