Znote (recipes)
  Get Znote  

SQL query on local database

How to make SQL query on a local MySQL

 

Connect to a local SQL Database

👉 Install the Local SQL plugin 🧩

Drivers installed: Mysql, Postgres, Microsoft SQL server

//exec:node
const query = "select * from TABLE;";
const dialect = "mysql"; //'mysql' | 'postgres' | 'mssql'
const port = 3306; // mysql,mariadb=3306 postgres=5432 mssql=1433
const results = await getSQL(query, "localhost", port, dialect, "user", "password", "database");
printTable(results);
//printJSON(results);
//const results = await getSQLite(query, "/path/to/database.sqlite");

Related recipes