Jump to content

insert 2,500 records into mysql


galvin

Recommended Posts

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"

Link to comment
https://forums.phpfreaks.com/topic/190411-insert-2500-records-into-mysql/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.