Code changed in views

llauix posted 4 years ago in Running SQL scripts

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 posted 4 years ago
Sorry, i use Heidi Mysql 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:

Please login to leave a reply, or register at first.