Bug #4391 no database selected
Submitted: 3 Jul 2004 2:34 Modified: 4 Jul 2004 12:47
Reporter: Andrew Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Query Browser Severity:S1 (Critical)
Version:1.0.1 OS:Windows (Windows XP SP1)
Assigned to: Michael G. Zinner CPU Architecture:Any

[3 Jul 2004 2:34] Andrew 
Description:
I open query browser, click on the database and then the table, and then type

select * from interfaces;

and it says at the bottom

"No Database Selected Error Nr 1046"

How to repeat:
I open query browser, click on the database and then the table, and then type

select * from interfaces;

and it says at the bottom

"No Database Selected Error Nr 1046"
[3 Jul 2004 2:36] Andrew 
i'm using 1.0.1a by the way
[4 Jul 2004 12:47] Michael G. Zinner 
You have to specify the default schema at connection time (see the Schema: edit in the Connection Dialog) or by selecting File > Change Default Schema or by executing USE databasename.

If you do not specify a default schema at connection time, all schemata are equal. You have to do a select like this:

SELECT * FROM forum.posts