List:MySQL ODBC« Previous MessageNext Message »
From:Paul DuBois Date:June 13 2001 10:34pm
Subject:Re: maximun size of a query
View as plain text  
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
Thread
maximun size of a queryRosanne Possato8 Jun
Re: maximun size of a queryPaul DuBois14 Jun