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

MySQL "USE dbname" command

User, date Message
Written by this_is_me
5 months ago
Category: General
2 posts since Tue, 22 Apr 14
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!
Written by jfalchMoney, Euro
5 months ago
407 posts since Sat, 17 Oct 09
quick fix: use query
SELECT Database()
Written by ansgar
5 months ago
5023 posts since Fri, 07 Apr 06
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.
Written by ansgar
5 months ago
5023 posts since Fri, 07 Apr 06
Should be fixed in r4763
Written by this_is_me
5 months ago
2 posts since Tue, 22 Apr 14
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.