Large sql query, snipped at 2000 characters

[expired user #6827]'s profile image [expired user #6827] posted 11 years ago in Running SQL scripts Permalink
Hi, New to HeidiSQL but working my way around it. I have not been able to find a solution to the the problem of "large sql query (over 4.3 KB) snipped at 2000 characters
HeidiSQL v 7.0.0.4053 SQL5.5.24
db contains 270 columns only 7 records, and UPDATE step causes problem.
thanks
Gary P
ansgar's profile image ansgar posted 11 years ago Permalink
Hey, that's just an information in the log, how could that be some problem?
[expired user #6977]'s profile image [expired user #6977] posted 11 years ago Permalink
I upgraded to HeidiSQL 8 and got this message.
Version 7 doesn't give this message.
The query is certainly more than 2K but it is a a database backup and works faster that way.
Does it mean the query has not been run or it has not been run completely?
ansgar's profile image ansgar posted 11 years ago Permalink
Version 7 also does that, even 6.0 and 5.0/1, 4.0. The messages are cut only for not blowing up the log panel. Think of bulk INSERTs with 10mb of SQL in it - having a few of them would degrade performance of the underlying SynEdit component.
[expired user #6977]'s profile image [expired user #6977] posted 11 years ago Permalink
OK, that clarified things, thanks

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