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]