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

Feature Request: Querybuilder Not To Show Database Name

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Feature Request: Querybuilder Not To Show Database Name

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • June 19, 2009 at 2:53 pm #11546
      mford
      Member

      Would like option to turn off database name inclusion in sql generated by QueryBuilder. We share queries accross multiple databases and continually have to manually remove the db name.

      Want this…

      SELECT

      an_templates.id_template

      FROM

      analyzer01.an_graphs

      INNER JOIN an_templates

      ON (an_graphs.id_template = an_templates.id_template)

      INNER JOIN an_axis

      ON (an_axis.id_graph = an_graphs.id_graph)

      INNER JOIN an_channels

      ON (an_channels.id_axis = an_axis.id_axis)

      WHERE (an_templates.id_template = 1)

      Instead of this…

      SELECT

      an_templates.id_template

      FROM

      analyzer01.an_graphs

      INNER JOIN analyzer01.an_templates

      ON (an_graphs.id_template = an_templates.id_template)

      INNER JOIN analyzer01.an_axis

      ON (an_axis.id_graph = an_graphs.id_graph)

      INNER JOIN analyzer01.an_channels

      ON (an_channels.id_axis = an_axis.id_axis)

      WHERE (an_templates.id_template = 1)

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.