Module "mysql2" has no exported member "Types"

[neeppy]

Hello,

Apparently, when using typescript, the Types export from index.js is not being resolved. I assume this is because it's missing from the index.d.ts file.

However, logging out Types works as expected, even if it says that it's missing, so a simple @ts-ignore works as a workaround. Trying to import from the promise API, however, doesn't work, as expected, since the Types object is not exported.

Is there a reason why the column types couldn't be exported from mysql2/promise as well?

Thanks a lot!

[wellwelwel]

Hi @cptpaws, can you check it in version ^3.4.1?

---

Is there a reason why the column types couldn't be exported from mysql2/promise as well?

Now, you can import it from both mysql2 and mysql2/promise 🤹🏻‍♀️

---

Just a suggestion in case you use it with ES Module

To import the Constants, I recommend you do it as follows:

import mysql from 'mysql2';
// or
import * as mysql from 'mysql2';

// then
mysql.Types;

---

When using by this way in an ES Module

import { Types } from 'mysql2';

It will print an error like:

import { Types } from 'mysql2';
         ^^^^^
SyntaxError: Named export 'Types' not found. The requested module 'mysql2' is a CommonJS module, which may not support all module.exports as named exports.
CommonJS modules can always be imported via the default export, for example using:

import pkg from 'mysql2';
const { Types } = pkg;

---

As before, it's just a suggestion 🙋🏻‍♂️

[wellwelwel]

After version ^3.4.1, you can use the Types constants.

Some examples:

• import mysql from 'mysql2'
  

  node-mysql2/test/tsc-build/mysql/constants/Types.ts

  Lines 3 to 5 in 4ac6a8f

  	const BLOB: number = mysql.Types.BLOB;
  	const DECIMAL: string = mysql.Types[0x00];
  	const DOUBLE: string = mysql.Types[5];

• import mysql from 'mysql2/promise'
  

  node-mysql2/test/tsc-build/promise/constants/Types.ts

  Lines 3 to 5 in 4ac6a8f

  	const BLOB: number = mysql.Types.BLOB;
  	const DECIMAL: string = mysql.Types[0x00];
  	const DOUBLE: string = mysql.Types[5];

---

I'm closing this Issue, but feel free to ask anything 🙋🏻‍♂️