Max length of query ?

dmark posted 10 years ago in General
Hello !

Is there a maximum length a query can have ?

I just loaded a big SQL dump (about 105 Megabyte) into HeidiSQL. There was no error message but the Character counter above the query text field showed a length of "05.928.600 Characters".

There was no error message when executing the query so I think the formatting of the number is simply broken. Is this right or is there a real limit?

ansgar posted 10 years ago
That is most probably a minor graphical glitch - the label which displays this number is not wide enough to hold large numbers. I should set its AutoSize property to true I guess.

Please login to leave a reply, or register at first.