Hi,
Thanks for the reply. Now I also manipulate it using PHP script to loop
every 1000 of records.
Regards,
Willy
On Tue, 2008-05-20 at 11:48 +0800, Moon's Father wrote:
> To make the parameter max_allowed_packet larger.
>
> On Mon, May 19, 2008 at 12:17 PM, sangprabv <[EMAIL PROTECTED]>
> wrote:
> Hi,
> Currently in my production environment, mysql only allow max
> 50.000
> records per insert. Is it possible to increase the number of
> records
> inserted during insert into query? How to do it? TIA
>
> Regards,
>
>
> Willy
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>
> --
> I'm a mysql DBA in china.
> More about me just visit here:
> http://yueliangdao0608.cublog.cn
--
[sangprabv]
http://www.sangprabv.web.id
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]