distal-attribute
distal-attribute
distal-attribute
distal-attribute

Large sql query, snipped at 2000 characters

gazza01 posted 2 years ago in Running SQL scripts
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 posted 2 years ago
Hey, that's just an information in the log, how could that be some problem?
arnuxii posted 2 years ago
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 posted 2 years ago
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.
arnuxii posted 2 years ago
OK, that clarified things, thanks

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