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

MySQL "USE dbname" command

this_is_me posted 8 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 8 months ago
quick fix: use query
SELECT Database()
ansgar posted 8 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 8 months ago
Should be fixed in r4763
this_is_me posted 8 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.