At 5:35 PM -0300 6/8/01, Rosanne Possato wrote:
>Hi friends,
>
>When I try to insert more than 20.000 lines in a table through a single
>"insert" , MySQL returns an error and doesn't insert the data. Each line is
>composed by 5 fields (4 unsigned int fields and a datetime field). Is there
>any variable that limits the size of a query in MySQL? (The query works with
>20.000 lines)
The max_allowed_packet variable. To make it bigger, you'll need to
change it for both your client and for the server.
>
>Thank you,
>Rosanne
>
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail myodbc-thread3422@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail myodbc-unsubscribe@stripped instead.
--
Paul DuBois, paul@stripped
