How to access and operate mysql database with nodejs-JS Tutorial-php.cn

How to access and operate mysql database with nodejs

小云云

Release： 2018-03-16 09:16:50

Original

1933 people have browsed it

This article mainly introduces the simple method of nodejs to access and operate mysql database. It analyzes the related operation skills of nodejs to create mysql connection, execute sql statement and close the connection in the form of examples. Friends who need it can refer to it. I hope it can help. to everyone.

var mysql = require(&#39;mysql&#39;); //调用MySQL模块 mysql模块要安装 $ npm install mysql
//创建一个connection
var connection = mysql.createConnection({
  host   : &#39;127.0.0.1&#39;,    //主机
  user   : &#39;root&#39;,        //MySQL认证用户名
  password : &#39;&#39;,    //MySQL认证用户密码
  port: &#39;3306&#39;,          //端口号
  database:&#39;&#39;   //数据库名
});
//创建一个connection
connection.connect(function(err){
  if(err){
    console.log(&#39;[query] - :&#39;+err);
    return;
  }
  console.log(&#39;[connection connect] succeed!&#39;);
});
//执行SQL语句
connection.query(&#39;SELECT 1 + 1 AS solution&#39;, function(err, rows, fields) {
  if (err) {
    console.log(&#39;[query] - :&#39;+err);
    return;
  }
  console.log(&#39;The solution is: &#39;, rows[0].solution);
});
//关闭connection
connection.end(function(err){
  if(err){
    return;
  }
  console.log(&#39;[connection end] succeed!&#39;);
});

Copy after login

Note: nodejs does not need to set the encoding format of the database when operating the database set names utf8

Related recommendations:

PHP operates MySQL database

php operates some commonly used built-in functions of mysql database

Introduction to using node to operate mysql database instance

The above is the detailed content of How to access and operate mysql database with nodejs. For more information, please follow other related articles on the PHP Chinese website!