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?
HeidiSql editor not identifying Loop identifiers
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.
I've also looked at
http://www.heidisql.com/forum.php?t=11376
and quite a few stack overflow pages.
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.
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.
Please login to leave a reply, or register at first.