Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Formatting of View definitions

Wolfgang Jacques's profile image Wolfgang Jacques posted 6 years ago in General Permalink
Hello everyone,
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
wibu_rp's profile image wibu_rp posted 6 years ago Permalink
I have the same problem. Views are nearly unusable with that behaviour.
johnb's profile image johnb posted 5 months ago Permalink

I confirm that this problem still exists in 15/4/2021 in HeidiSQL 11.2.0.6213 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.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.