Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Query Builder and Schema Designer › Query Without Database Name
Hello !
To create the query, I use the Query Builder.
An example:
SELECT `property_name` FROM `myDatabase`.`properties`;
Is there a way to switch off the database name ?
Your sincerly
Stephan
Hi Stephan,
This feature request is already listed in our issue tracker,
http://code.google.com/p/sqlyog/issues/detail?id=1107
Right now priority is not set. We will discuss regarding this feature and prioritize accordingly.
Regards,
Ashwin A
Once you have copied into the editor you can 'search and replace': `myDatabase`. –> (empty string).
The problem is that when we load a XML we validate that refered tables and colums are there (I think!). For this we need the database name.