What is "Maximal length of created query" on phpmyadmin?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
pjcvijay
Forum Commoner
Posts: 25
Joined: Tue Sep 09, 2008 6:12 am

What is "Maximal length of created query" on phpmyadmin?

Post by pjcvijay »

Hi All,
When I export my database using phpmyadmin, it shows "Maximal length of created query" option. What does it mean?
Any idea my dear friends?

Thanks in advance,
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: What is "Maximal length of created query" on phpmyadmin?

Post by Eran »

When exporting data in phpMyAdmin, it prepares single insert operations with multiple values. Depending on the number of records in a table, this query could be very long. If the physical size of the query exceeds the max_allowed_packet parameter in MySQL, the query would break. For this purpose, phpMyAdmin gives you the option to limit the size of individual queries, splitting long insert queries into several smaller ones.
pjcvijay
Forum Commoner
Posts: 25
Joined: Tue Sep 09, 2008 6:12 am

Re: What is "Maximal length of created query" on phpmyadmin?

Post by pjcvijay »

This is very helpful to me. Thank you for your response my friend!
Post Reply