Bug #7256 double-click on a table generate sql without database name
Submitted: 14 Dec 2004 9:55 Modified: 15 Dec 2004 8:51
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.3 OS:Windows (windows 2000)
Assigned to: CPU Architecture:Any

[14 Dec 2004 9:55] [ name withheld ]
Description:
when double-click on a table, there's not automaticaly the database name with table on the generated sql code. We have to add it manually everytime. (depend perhaps of MYsql server, but mysqlcc don't ask for a database name when it generate sql code)

How to repeat:
just click on table, and execute button

perhaps the mysql installation should be a 'basic' installation like the Mandrake dist i've got
[14 Dec 2004 21:48] pwm
I'm running 1.1.3 on WinXP. Instead of missing the table name in the generated query text, I get the table name followed by a space and the first character of the table name repeated again, i.e.:

SELECT * from customers c
[15 Dec 2004 8:18] [ name withheld ]
the first character that is repeated, is not a bug. it's just the way to do an alias of the table name.

ie : SELECT * from db.customers c where c.phone='911'
[15 Dec 2004 8:51] Michael G. Zinner
MySQL supports a "default" schema. It can be chosen 

* in the Connection Dialog
* with the right mouse button in the schemata tree
* with the menu entry File > Change Default Schema ...
* by typing USE `schema_name`

SELECTs against the default schema don't need the schema name in it, simply because it is the default. The only place where you have to use the database name is when you join or select data from a table in another schema.

So, e.g. when you specify the `test` schema in the connection dialog and in QB doubleclick a table from the `mysql` schema you will get

SELECT * FROM mysql.db d

but from a table in the `test` schema

SELECT * FROM city c