I create a new view with this declaration:
select title,author from books
when we want to edit this view, editor shows the code like this:
select `books`.`title` AS `title`,`books`.`author` AS `author` from `books`[i][/i]
how do we can prevent this? when the statement is simply no problem but when the statement is long is inconvenient.
Thanks you very much in advance.
Code changed in views
llauix posted 4 years ago
Sorry, i use Heidi Mysql 22.214.171.12467 on windows.
ansgar posted 4 years ago
HeidiSQL already tries its best to retrieve the original view code from the server. However, the server silently does this conversion. See here for a prior discussion: https://code.google.com/p/heidisql/issues/detail?id=3134
Please login to leave a reply, or register at first.