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

Large sql query, snipped at 2000 characters

User, date Message
Written by gazza01
1 year 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
1 year ago
4793 posts since Fri, 07 Apr 06
Hey, that's just an information in the log, how could that be some problem?
Written by arnuxii
11 months 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
11 months ago
4793 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
11 months ago
2 posts since Mon, 27 May 13
OK, that clarified things, thanks
 

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