HeidiSql editor not identifying Loop identifiers

[expired user #6780]'s profile image [expired user #6780] posted 11 years ago in General Permalink
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?
[expired user #6780]'s profile image [expired user #6780] posted 11 years ago Permalink
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.
ansgar's profile image ansgar posted 11 years ago Permalink
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.
kalvaro's profile image kalvaro posted 11 years ago Permalink
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.