Trying to find any information on this via google is ridiculous, considering the term "LIMIT" can be part of almost any MySQL statement...

I'm curious if there's an upper limit to the number of value sets you can include in a single INSERT, for eg;

INSERT INTO `table` (row_one, row_two) VALUES ('x', 'x'), ('x', 'x'), ('x', 'x'), ('x', 'x'), ('x', 'x') .....

I noticed that when you do an SQL dump from phpMyAdmin it iterates a new INSERT every 200 rows or so, but the number varies, give or take 15 rows. So I'm assuming this is just to keep your import from timing out more than following any rigid rules.

Anybody here know?