node-mysql2 icon indicating copy to clipboard operation
node-mysql2 copied to clipboard

bigNumberStrings: true is not return type number

Open thanathip41 opened this issue 1 year ago • 0 comments

import mysql, { PoolOptions } from 'mysql2'; // version 3.1.0

const options = {
  user: 'test',
  database: 'test',
  // .......
  supportBigNumbers: true,
  bigNumberStrings: true
};
const pool = mysql.createPool(options);
// when i use 
pool.query("SELECT count(*) as total FROM users WHERE `users`.`deleted_at` IS NULL LIMIT 3")

The total return type string

Thank you

thanathip41 avatar Jun 14 '24 03:06 thanathip41