distal-attribute
distal-attribute
distal-attribute
distal-attribute

MySQL "USE dbname" command

this_is_me posted 10 months ago in General
Hi,
When I do the "USE dbname" command and I have done it in different databases there is no way that I can see which Database is currently selected.
Is it possible to highlight the database that is currently in use?
Hope I'm clear enough.
Thanks!
jfalch posted 10 months ago
quick fix: use query
SELECT Database()
ansgar posted 10 months ago
HeidiSQL should magically detect those USE queries and highlight the one in the left database tree. But that's broken somehow. I'm just going to fix that.
ansgar posted 10 months ago
Should be fixed in r4763
this_is_me posted 10 months ago
Clicking on the database gives the following errors.

SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='';
/* Result #1 fetched. */
/* Ping server ... */
SHOW TABLE STATUS FROM ``;
/* SQL Error (1102): Incorrect database name '' */
/* Ping server ... */
SHOW FUNCTION STATUS WHERE `Db`='';
/* Result #1 fetched. */
/* Ping server ... */
SHOW PROCEDURE STATUS WHERE `Db`='';
/* Result #1 fetched. */
/* Ping server ... */
SHOW TRIGGERS FROM ``;
/* SQL Error (1102): Incorrect database name '' */
/* Ping server ... */
SHOW EVENTS FROM ``;
/* SQL Error (1102): Incorrect database name '' */

Please login to leave a reply, or register at first.