Code changed in views

llauix posted 4 years ago in Running SQL scripts
Hi,

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.

Llauix.
llauix posted 4 years ago
Sorry, i use Heidi Mysql 9.1.0.4867 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.