Large inserts, chunking and Concat

[John Ling]

Hello, realizing that there is a max_allowed_packet setting that limits 
the size of the insert statement, is there a way around it by chunking 
the query?

In particular, if the query is to insert a large text or blob, can I 
simply concatenate smaller pieces of the data in succession using the 
Concat command?

My concern is whether this will still in someway cause me other MySQL 
resource problems?

I want to be able to insert a large text or blob of over 200-400MBs.
Thanks,
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]