Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Alter View Not Formatted For Linebreaks Or Padding

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Alter View Not Formatted For Linebreaks Or Padding

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 6, 2007 at 12:06 am #10527
      Simeon
      Member

      Alter view outputs view statement all on one line with no line breaks or indentation.

      Alter view also seems to ignore the setting of “Generate queries using backquote(`)” and generates using backquotes regardless.

      This appears to be a mysql 'feature' in that even if I generate a view using the official MySQL Query Browser, the resulting record in the `information_schema`.`view' table has backquotes. Also if I 'Edit View' in MySQL Query Browser, the view is presented all on one line.

      Could it be that MySQL does not store linebreaks or other 'formatting' characters in views?

    • September 6, 2007 at 9:14 am #24885
      peterlaursen
      Participant

      Just like your post about Stored Procedures this is a MySQL issue.

      1) MySQL returns the create statement like that

      2) the setting if preferences can only have effect on statements generated by SQLyog – not whne a complete CREATE statement is returned by the MySQL server.

      You may say and think that we should do some parsing and formatting on the client side.

      We try to avoid it. We think MySQL AB should solve those issues!

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.