[DarkShadowSwE]

fishy place to put the setting, thought it would be under the “Generate queries using backquotes(`)” in preferences, but its still a realy nice feature, cheers.

[DarkShadowSwE]

'peterlaursen' wrote:

OK .. I think you have a point.

1) If the query you generate should be executed from SQLyog the fully qualified table name makes sense, because if you change the databae context the query will fail (at best).

2) But if you generate a query solely with the purpose to use it in an application/script where the database name may be different, a query without the database name would be useful.

ye, number two describes what i do sins i make the queries in sqlyog and then paste them into PHP scripts, and sins i use 1 development DB and 1 live DB it would be usefull to not have to delete the database name every single time.

'sathish' wrote:

Hello,

This feature request is already listed in our issue tracker: http://code.google.com/p/sqlyog/issues/detail?id=1107 we will schedule this according to priority.

Regards,

Sathish

ye , true, it was added… , over 2.5 years ago…, and even tho several people have asked for the feature in the last 2 years it still havent been added…

[DarkShadowSwE]

'peterlaursen' wrote:

Is it a big deal to 'search and replace' (CTRL+H) “`databasename`.” with an empty string after copying to editor?

i think os yes , sins im sitting all day working in sqlyog on 1 screen and notpad++ onm the other , would be much better to just have an option to remove it like the remove ´ option.

[DarkShadowSwE]

i would like to have an option to remove the “database.tablename” from queries made with the builder like the ´ could be removed.

exampel:

SELECT table1.*, table2.*

FROM dbnamehere.table1 LEFT JOIN dbnamehere.table2 ON (table1.t1ID = table2.t2ID)

WHERE ….

=

SELECT table1.*, table2.*

FROM table1 LEFT JOIN table2 ON (table1.t1ID= table2.t2ID)

WHERE ….

with no “dbnamehere.”

[Author]

Posts