Formatting of View definitions
when composing a view, I take care to format the SQL with indentations and many lines so I can understand it later. Now I have two systems:
1.) Win 7 with locally installed mySQL 5.1.63 - when I open a formerly saved view definition, it looks fine.
2.) Win 7 with remotely installes mySQL 5.1.?? on Linux - when I open a formerly saved view definition, it is shown in one line only with "`" around every table and column name.
It looks like on system 2.) the View definition is parsed somehow before saving oder retrieving ...
How can I prevent that? (I am not referring to the Ctrl-F8 feature, I would rather keep my own Layout)
Thank you, regards, Wolfgang
I confirm that this problem still exists in 15/4/2021 in HeidiSQL 220.127.116.1113 for Windows, when you connect to MySQL 8.0.23 in Linux.
The formatting of MySQL functions though is showing correctly (lines feeds are showing correctly and the code inside the MySQL function is preserved between saves).
Is there any solution for this problem?
Please login to leave a reply, or register at first.