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

HeidiSql editor not identifying Loop identifiers

User, date Message
Written by davidk
2 years ago
Category: General
3 posts since Tue, 29 Jan 13
Hey everyone, been using HeidiSQL recently and I love it! It's like having Sql Server Management Studio on steroids for MySql.

No matter what SQL Editor I'm in, I can't use a WHILE or LOOP statement. It never highlights the syntax, leaves it black, and gives me a 1064 error when saving. I saw a similar question that dealt with the delimiter but I don't think that is the problem. Any suggestions?
Written by davidk
2 years ago
3 posts since Tue, 29 Jan 13
Little extra, both of these keywords are in the SQL Keywords dropdown tree to the right of the query window. All the other keywords when dragged appear blue and highlighted, but not the WHILE and LOOP keywords.


I've also looked at
http://www.heidisql.com/forum.php?t=11376

and quite a few stack overflow pages.
Written by ansgar
2 years ago
4973 posts since Fri, 07 Apr 06
Are you on MSSQL or on MySQL? The syntax highlighter distincts between these two servers.

But do not care too much about syntax highlighting. There may be some keywords missing in the internal highlighter. The only important thing is that the server recognizes your SQL code when pressing F9 to execute it.
Written by kalvaro
2 years ago
592 posts since Thu, 29 Nov 07
Error 1064 is a parse error triggered by MySQL server itself. I suspect it has nothing to do with HeidiSQL. You are probably writing a stored routine and you didn't get the syntax right (it can be tricky).
 

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