How to connect MySQL in Nodejs, here is a small demo.
The first step is to install the MySQL module
NPM install MySQL
The second step is to import the MySQL module
var mysql = require (' mysql ');
Third step to connect MySQL database
var connection = Mysql.createconnection ({
Host: ' localhost ',
User: ' Root ',
Password: ",
Database: ' Yudi '
});
Connection.connect ();
The fourth step executes a query statement
var sql = "Select * from the person where name= '" +username+ "";
Connection.query (Sql,function (err,rows,fields) {
if (ERR)
Console.log (ERR);
else{
Console.log (rows);
}
Remember to close the connection
Connection.end ();
});
ERR: is an error message
Rows: Information for queries
Fields: Return all information
Here is the demo
var mysql = require (' mysql '); var connection = Mysql.createconnection ({ host: ' localhost ', User: ' Root ', Password: ', database: ' Yudi '}); Connection.connect (); var username = ' STU2 '; var sql = "Select * FROM person where name= ' "+username+" ' "; Connection.query (Sql,function (err,rows,fields) { if (err) console.log (err); else{ console.log (rows); } Connection.end ();//Remember to close the connection});
How to connect MySQL in Nodejs