HeidiSql editor not identifying Loop identifiers

davidk posted 5 years ago in General
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?
davidk posted 5 years ago
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

and quite a few stack overflow pages.
ansgar posted 5 years ago
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 posted 5 years ago
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.