MySQL Forums
Forum List  »  Views

Comments and sql formatting in views
Posted by: Antonio Garcia
Date: June 27, 2017 05:56AM


This is really odd.

I have a few servers running different version of MySQL (5.4, 5.5., 5.6, 5.7...).
When creating a view like the one below in all servers some of them change the SQL query completely and take the comments out...but some others keep the format and the comments. I have checked everything, version of MySQL, my.conf...but I cannot find what the option is to keep or not the format and comments in.

SELECT * FROM table1

=> changed to

SELECT 'table1'.'field1','table1','field2' from 'table1'


Options: ReplyQuote

Written By
Comments and sql formatting in views
June 27, 2017 05:56AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.