remove database name on queries

ddandre's profile image ddandre posted 2 weeks ago in General Permalink

Hi,

By default, HeidiSQL includes the database name in every query. For example:

DELETE FROM`dbtest`.`test_table` WHERE `id`=15;

INSERT INTO `dbtest`.`test_table` (`id`, `name`) VALUES (13, 'Testentry'); `

How can I disable this behavior?

ansgar's profile image ansgar posted 2 weeks ago Permalink

You can't disable that. It is hardcoded, and there are some reasons for keeping it, mostly because in the background the user may have selected a different database.

ddandre's profile image ddandre posted 2 weeks ago Permalink

That's too bad. Thanks for the quick response.

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