the function of "Run current query" has a wrong that can't actually run the current line query, it will run whole sql in editor. just like that:
// two sql seperate by \r\n
select * from table_a
select * from table_b
when I put cursor at the line "select * from table_b" and right click "run current query", but the sql is not I expect, it's wrong: "select * from table_a select * from table_b", therefore, the error: "/* SQL Error (1064): You have an error in your SQL syntax" will be appear in log window.
however, I think this is a low level bug and it's easy to fix, I am hoping fix it sooner.
By the way, heidisql version is 7.0.0.4053 and 7.0.0.4078 exist this bug.
I found a bug about "Run current query"
HeidiSQL 5 did not have the "Run current query" action. Instead there was a "Run current line", which you likely used.
Now, there was quite some discussion on this "Run current line" action, so I finally turned it into a "Run current query", which now includes carriage returns, and is much more what most users need, while MySQL itself always supports multiple lines in a query.
Now, there was quite some discussion on this "Run current line" action, so I finally turned it into a "Run current query", which now includes carriage returns, and is much more what most users need, while MySQL itself always supports multiple lines in a query.
Please login to leave a reply, or register at first.