mysql-queries

library0.2.0jsnpmunverified

A minimal utility for executing multiple MySQL queries with a single callback, simplifying batch operations. The current stable version is 0.2.0, released in an early stage with infrequent updates. It wraps the 'mysql' npm package, supporting connection pooling, transactions, and automatic connection release. Unlike more modern libraries like 'mysql2' or ORMs like 'Sequelize', it provides a thin layer for sequential query execution without promises or async/await support, relying on callbacks. Suitable for legacy Node.js projects or quick scripts where minimal overhead is desired.

database

npm install mysql-queries

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · MYSQL-QUERIES

mysql-queries

databasejavascriptv0.2.0

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

default

✓ import mysqlQueries from 'mysql-queries'

✗ const mysqlQueries = require('mysql-queries')

ESM default import works; CommonJS require is also valid.

init

✓ import mysqlQueries from 'mysql-queries'; mysqlQueries.init(options)

✗ import { init } from 'mysql-queries'; init(options)

init is a method on the default export, not a named export.

queries

✓ import mysqlQueries from 'mysql-queries'; mysqlQueries.queries(sqls, params, callback)

✗ const { queries } = require('mysql-queries'); queries(sqls, params, callback)

queries is a method on the default export, not a named export.

query

✓ import mysqlQueries from 'mysql-queries'; mysqlQueries.query(sql, callback)

✗ const mysqlQueries = require('mysql-queries').query; mysqlQueries(sql, callback)

query is a method on the default export, not a standalone function.

Initializes the library with a MySQL connection, then executes two SQL queries sequentially with parameters, logging results or errors.

import mysqlQueries from 'mysql-queries'; const options = { host: 'localhost', port: 3306, user: 'user', password: 'pass', database: 'test' }; mysqlQueries.init(options); const sqls = [ 'SELECT * FROM prod_unit WHERE name=? LIMIT 1', 'INSERT INTO prod_unit(name) VALUES(?)' ]; mysqlQueries.queries(sqls, [['unit1'], ['unit1']], (err, results) => { if (err) { console.error(err); } else { console.log(results); } });

Debug

Known issues

gotchaThe 'init' function must be called before any query method; re-initialization overrides previous connection settings.

affects: >=0.0.0

gotchaNo promise or async/await support; all operations use callbacks.

affects: >=0.0.0

gotchaResults array indices correspond to SQL array order; errors in one query stop execution and callback with error.

affects: >=0.0.0

gotchaThe 'mysql' package must be installed separately; it is a direct dependency but not bundled.

affects: >=0.0.0

deprecatedThe 'mysql' npm package is no longer maintained; consider using 'mysql2' which is not supported by this library.

fix

Migrate to a library like 'mysql2' with promise support.

affects: >=0.0.0

Errors

Common errors & fixes

TypeError: mysqlQueries.init is not a function

Importing named export 'init' instead of default export.

fix

Use 'import mysqlQueries from "mysql-queries"' instead of 'import { init } from "mysql-queries"'.

Cannot find module 'mysql'

The peer dependency 'mysql' is not installed.

fix

Run 'npm install mysql' (version 2.x) as a project dependency.

TypeError: sqls is not iterable

Passing a string instead of an array for SQLs.

fix

Wrap single SQL in an array: '["SELECT 1"]'.

Upgrade

Version history

0.2.0latest on npm

Audit

Dependencies

mysqlrequiredRequired as the underlying MySQL driver for database connectivity.

Agent activity

8 hits · last 30 days

node

Resources

githubhttps://github.com/zzzhan/nodejs-mysql-queries ↗

packagemysql-queries ↗

homepagehttps://github.com/zzzhan/nodejs-mysql-queries#readme ↗