你不会用node 操作mysql数据库吗？

http://static.runoob.com/download/websites.sql
这是实例 websites.sql文件
1、安装node的mysql服务

npm install mysql

以下代码全是在test.js中，输入下面命令：

node test.js

2、链接到sql



var mysql      = require('mysql');

var connection = mysql.createConnection({

  host     : 'localhost',

  user     : 'root',

  password : '123456',

  database : 'test'

});

connection.connect();

connection.query('SELECT 1 + 1 AS solution', function (error, results, fields) {

  if (error) throw error;

  console.log('The solution is: ', results[0].solution);

});

3、查询数据

var mysql  = require('mysql');  

var connection = mysql.createConnection({

  host     : 'localhost',

  user     : 'root',

  password : '123456',

  port: '3306',

  database: 'test'

});

connection.connect();

var  sql = 'SELECT * FROM websites';

//查

connection.query(sql,function (err, result) {

        if(err){

          console.log('[SELECT ERROR] - ',err.message);

          return;

        }

       console.log('--------------------------SELECT----------------------------');

       console.log(result);

       console.log('------------------------------------------------------------\n\n');

});

connection.end();

4、插入数据



var mysql  = require('mysql');  

var connection = mysql.createConnection({

  host     : 'localhost',

  user     : 'root',

  password : '123456',

  port: '3306',

  database: 'test'

});

connection.connect();

var  addSql = 'INSERT INTO websites(Id,name,url,alexa,country) VALUES(0,?,?,?,?)';

var  addSqlParams = ['菜鸟工具', 'https://c.runoob.com','23453', 'CN'];

//增

connection.query(addSql,addSqlParams,function (err, result) {

        if(err){

         console.log('[INSERT ERROR] - ',err.message);

         return;

        }        

       console.log('--------------------------INSERT----------------------------');

       //console.log('INSERT ID:',result.insertId);

       console.log('INSERT ID:',result);

       console.log('-----------------------------------------------------------------\n\n');

});

connection.end();

5、更新数据

更多内容请见原文，原文转载自：https://blog.csdn.net/weixin_44519496/article/details/119836384

巴特西

你不会用node 操作mysql数据库吗？

最新文章

热门文章