node.js mysql 连接使用

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了node.js mysql 连接使用，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2650字，纯文字阅读大概需要4分钟。

内容图文

https://www.runoob.com/nodejs/nodejs-mysql.html

* restgo.sql

create database if not exists restgo;

use restgo;

CREATE TABLE `websites` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `url` varchar(255) NOT NULL,
  `alexa` varchar(32) DEFAULT NULL,
  `country` varchar(8) DEFAULT '' COMMENT 'runoob websites test',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

* connect.js

// npm install mysql --save

const mysql = require('mysql');
var connection = mysql.createConnection({
    host: '172.16.0.224',
    user: 'root',
    password: 'Mzh123',
    database: 'restgo'
});

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);

    connection.destroy();
});

D:\opt\xampp\mysql\bin\mysql.exe -uroot -h172.16.0.224 -pMzh123

>node connect.js
The solution is:  2

* insert.js

// npm install mysql --save

const mysql = require('mysql');
const connection = mysql.createConnection({
    host: '172.16.0.224',
    user: 'root',
    password: 'Mzh123',
    database: 'restgo'
});

connection.connect();

let sql = "INSERT INTO websites(name, url, alexa, country) values(?,?,?,?)";
// let params = ['菜鸟工具', 'https://c.runoob.com','23453', 'CN'];
let params = ['Google', 'https://www.google.com','1', 'USA'];

connection.query(sql, params,function(err, results) {
    if (err) {
        console.log('[INSERT ERROR] - ', err.message);
        return;
    }
    console.log(results);

    connection.destroy();
});

/**
 OkPacket {
  fieldCount: 0,
  affectedRows: 1,
  insertId: 1,
  serverStatus: 2,
  warningCount: 0,
  message: '',
  protocol41: true,
  changedRows: 0 }

 MySQL [restgo]> select * from restgo.websites;
 +----+----------+----------------------+-------+---------+
 | id | name     | url                  | alexa | country |
 +----+----------+----------------------+-------+---------+
 |  1 | 菜鸟工具 | https://c.runoob.com | 23453 | CN      |
 +----+----------+----------------------+-------+---------+
 1 row in set (0.00 sec)

 */

* select.js

// @ref: https://www.runoob.com/nodejs/nodejs-mysql.html
// npm install --save mysql
// npm install --save bluebird
const mysql = require('mysql');
const bluebird = require('bluebird');

var connection = mysql.createConnection({
    host: '172.16.0.224',
    user: 'root',
    password: 'Mzh123',
    database: 'restgo'
});

connection.connect();

connection = bluebird.promisifyAll(connection);

connection.queryAsync("SELECT * FROM websites").then(function (rows) {
    console.log(JSON.stringify(rows));
    connection.destroy();
});

>node select.js
[{"id":1,"name":"菜鸟工具","url":"https://c.runoob.com","alexa":"23453","country":"CN"},{"id":2,"name":"Google","url":"https://www.google.com","alexa":"1","country":"U
SA"}]
 

内容总结

以上是互联网集市为您收集整理的node.js mysql 连接使用全部内容，希望文章能够帮你解决node.js mysql 连接使用所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端