CODEWITHSUNDEEP
mysqlsqlcharacterlimit
Filippo oretti
Filippo oretti

Reputation: 49813

SQL which is a query chars limit?

Does anyone can tell me if is there any chars limit for a query?

I'm wondering cause I need to build up a big routine query and not sure if the query should have a chars limit.

i'm using : MySQL latest version , Apache 2, and PHP

Upvotes: 2

Views: 1383

Answers (1)

Tom
Tom

Reputation: 6663

Here's a couple good articles I found on the subject. The second article is actually referred to in the first article.

Maximum length of MySQL query? http://bytes.com/topic/php/answers/8519-maximum-length-mysql-query

Packet too Large - MySQL http://www.devshed.com/c/a/MySQL/Troubleshooting-Problems-with-MySQL-Programs/4/

Upvotes: 2

Related Questions