import { PageTitle } from '@site/src/components/PageTitle';

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:

<hr />

Examples

Please check these examples for MySQL2.

<hr />

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,
}

<hr />

<hr />