Jump to content


Photo

Query Without Database Name


  • Please log in to reply
2 replies to this topic

#1 Stephan123

Stephan123

    Member

  • Members
  • PipPip
  • 27 posts

Posted 01 September 2011 - 11:31 AM

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

#2 ashwin

ashwin

    Advanced Member

  • Members
  • PipPipPip
  • 275 posts
  • Gender:Male
  • Location:Bangalore, India

Posted 02 September 2011 - 04:33 AM

Hi Stephan,

This feature request is already listed in our issue tracker,
http://code.google.c.../detail?id=1107

Right now priority is not set. We will discuss regarding this feature and prioritize accordingly.

Regards,
Ashwin A

#3 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,869 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 02 September 2011 - 07:50 AM

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.


Computers make your grey hair come off ....

Peter Laursen
Webyog




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users