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: | |
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 ]
[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