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

Large sql query, snipped at 2000 characters

User, date Message
Written by gazza01
2 years ago
Category: Running SQL scripts
1 posts since Mon, 25 Feb 13
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
Written by ansgar
2 years ago
4973 posts since Fri, 07 Apr 06
Hey, that's just an information in the log, how could that be some problem?
Written by arnuxii
1 year ago
2 posts since Mon, 27 May 13
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?
Written by ansgar
1 year ago
4973 posts since Fri, 07 Apr 06
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.
Written by arnuxii
1 year ago
2 posts since Mon, 27 May 13
OK, that clarified things, thanks
 

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