Skip to main content

Documentation

MySQL2 aims to be a drop in replacement for Node MySQL.

note

If you see any API incompatibilities with Node MySQL, please report via github issue.

Not only MySQL2 offers better performance over Node MySQL, we also support these additional features:


Examples​

Please check these examples for MySQL2.


Known incompatibilities with Node MySQL​

  • zeroFill flag is ignored in type conversion. You need to check corresponding field's zeroFill flag and convert to string manually if this is of importance to you.

  • DECIMAL and NEWDECIMAL types always returned as string unless you pass this config option:

{
decimalNumbers: true,
}
note

This option could lose precision on the number as Javascript Number is a Float!

  • By default, the JSON type is always returned parsed into an object. However, you can modify this behavior by specifying the following configuration:
{
jsonStrings: true,
}

Other Resources​


Benchmarks​