Search code examples
mysqlnode.jstypescriptnode-mysql

'Cannot find module' when import in TypeScript

I have a small problem with importing nodejs modules. For http module this syntax is working well:

import * as http from "http";

But when I try to do the same with 'mysql2' node.js module:

import * as database from "mysql2";

I gave me an error:

Cannot find module 'mysql2'

And refuse to compile that line. I even tried syntax like this (don't know why):

import {database} from 'mysql2';

But there's no error only when I write like this:

let database = require('mysql2');

In tsconfig.json I've set:

"module": "commonjs",
"moduleResolution": "node",

And of course I've already installed the modules through npm in project folder:

npm install mysql2 --save

So my question is, why the import don't work and I have error in Visual Studio Code?

Solution

  • I think the import does not work because you are missing typescript definitions for mysql2. You have not posted your typings.json (or tsd.json) but I guess for nodejs you have imported definitions, but not for mysql2, therefore you can import 'http' using 'import from' syntax and with mysql2 you have to use plain javascript nodejs 'require' for importing it.