Re: maximum insert records per query?

2008-05-20 Thread sangprabv
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]



Re: maximum insert records per query?

2008-05-19 Thread Moon's Father
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