search

barklan / inline_sql_syntax

Highlight and lint inline SQL strings.
https://marketplace.visualstudio.com/items?itemName=qufiwefefwoyn.inline-sql-syntax
MIT License
57 stars 24 forks source link

MySQL dbDriver: is it possible to automatically select a database in settings.json? #101

Open martinfr87 opened 1 year ago

martinfr87 commented 1 year ago

With the MySQL driver, one must explicitly specify the database name in queries, eg.

SELECT name FROM mydatabase.customer

where 'mydatabase' is the name of the database. This is really annoying - would it be possible to have the extension automatically use a specified database? So that it would just be sufficient to type

SELECT name FROM customer

Thanks.