node. js Connection MySQL

Import the provided Websites table SQL file websites.sql into the MySQL database.

Problem found:

Found in the local database path, yes: C:\ProgramData\MySQL\MySQL Server 5.6\data This is ProgramData, not program Files.

and the MySQL installation directory: D:\Program files\mysql\mysql Server 5.6\data

Under the Data directory:

The default test and Information_schema do not have folders.

Import the SQL file into the MySQL database:

Log on to MySQL first, and then:

Mysql>use database;
Mysql>set names UTF8;
Mysql>source D:/aaa/nodejs--mysql/websites.sql;

Note that the path is with a backslash instead of a slash.

Querying data

After importing the SQL file we provided above into the database, execute the following code to query the data (code in Test.js):

node. js Connection MySQL