[ssaunders_2k]

ssaunders_2k wrote on Jun 30 2009, 03:02 PM:

I have attached the query to preserve the original formatting, but have renamed the table / field names – this still reproduces the problem originally reported.

Thanks

I should probably add, the SQL Formatting settings from the respective settings tab are:

[Table and Column List Style]

> Stacked (selected)

> Alignment of AS keyword and Aliases in Column Level (ticked)

> Linebreaks – After Comma (selected)

Indentation [ 2 ] spaces

[ssaunders_2k]

peterlaursen wrote on Jun 30 2009, 02:06 PM:

It would be easiest if you pasted the queries (or better: attach a .txt document with the original formatting).. We will not need any data. The text of the query itself is all we need.

You may create a ticket if you want privacy – and rename databases, tables etc.if you want as long as it is reproducable.

I have attached the query to preserve the original formatting, but have renamed the table / field names – this still reproduces the problem originally reported.

Thanks

[ssaunders_2k]

peterlaursen wrote on Jun 16 2009, 10:23 AM:

The query formatter works with SELECT, INSERT, UPDATE adn DELETE statements.

If you have something like

Code:

CREATE TEMPORARY TABLE temptab as SELECT .. FROM .. WHERE .. GROUP BY .. ORDER BY …

you may highlight the 'SELECT-part' with the mouse and this

Code:

SELECT .. FROM .. WHERE .. GROUP BY .. ORDER BY …

.. will format from the context-menu. Same applies to SELECT-part of VIEW definitions. Of course we should extend this feature, but nothing is scheduled for Query Formatter in near future. SQLyog issue tracker is public ( http://code.google.com/p/sqlyog/issues/list ) and there are more things to do.

Thanks.

I had gotten into the habit of using the F12 / Shift-F12 shortcuts I hadn't event noticed there was a 'format selected query' entry in the context menu 🙂

[Author]

Posts