1.下载mysql数据库
-
连接地址:https://dev.mysql.com/downloads/mysql/
2.在目录中下载mysql包
-
命令:npm install mysql
3.mysql操作代码
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
var mysql = require('mysql'); var connection = mysql.createConnection({ host : '主机名', user : '用户名', password : '密码', database : '库名称', port : '端口号' }); connection.connect(); connection.query('select * from 表名称', function (error, results, fields) { if (error) throw error; console.log(results) }); connection.end(); |