Sql Formatter

[ssaunders_2k]

I`m using SQLyog Enterprise v8.11 and find the SQL formatter feature very useful.

I have noticed that the query formatting isn't performed if the query begins 'create temporary table tmp_table_name' and I was just wondering if this is by design, if it's a bug, or if it's something that will be added in a future release ?

Thanks,

Steve

[peterlaursen]

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.

[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 🙂

[gloryforixseal]

Greetings

Excuse my bad English.

This tool Everest pro trial is very useful , but I cant insert my reports in Microsoft SQL . When I explore content of SQL base , Im not see any records in table “item”, but in table “report” I see the records.

I create reports and save it in CSV file, than insert in database by “database manager”.

How to fix it ?

[peterlaursen]

I know Everest program (from Lavalys, right?).

Please find help at http://www.lavalys.com. We cannot help here of course.

[Author]

Posts