@sqltags/mysql
v0.0.26
Published
MySQL driver for sqltags (@sqltags/core) 🔧✨ Safely create & execute parameterized SQL queries using template strings
Downloads
8
Maintainers
Readme
SqlTags MySQL driver
This is the MySQL driver for the @sqltags/core
library.
Please refer to the @sqltags/core project README for more information.
What is SqlTags?
🔧✨ Safely create & execute parameterized SQL queries using template strings.
const [user] = await sql`SELECT * FROM users WHERE id = ${userId}`;
Results in the following query:
SELECT * FROM users WHERE id = $1
-- with parameters: [123]
Installation & Usage
Install:
npm install mysql2 @sqltags/mysql
Create a MySQL connection, then create a MySQL tag using the connection:
import mysql from 'mysql2';
import { createMySqlTag } from '@sqltags/mysql';
const connection = mysql.createConnection({ /* ... */ });
const sql = createMySqlTag(connection);
Query:
const [user] = await sql`SELECT * FROM users WHERE id = ${userId}`;
Don't forget to disconnect your client when finished!
await connection.end();