Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert limit

Status
Not open for further replies.

TruthInSatire

Programmer
Aug 12, 2002
2,964
US
I've looked in the docs and searched google but can't seem to find the answer.

I'm inserting multiple records at a time

insert into myTable (x,y,z)
values (a,b,c),(d,e,f),(e,t,c)...

is there a limit to multiple inserts?
thanks.

Vegans are friends, not food...
 
Never mind, I just found out it's by packet size.

Packet for query is too large (1951601 > 1048576)

Vegans are friends, not food...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top