先安装npm模块项目
npm init
安装mysql
npm install mysql --save
Nodejs 连接msyql
const mysql = require('mysql');
const connection = mysql.createConnection({
host: '127.0.0.1',
user: 'root',
password: 'password',
port: '3306',
database: 'test'
});
connection.connect();
connection.end();
增
const mysql = require('mysql');
const connection = mysql.createConnection({
host: '127.0.0.1',
user: 'root',
password: 'password',
port: '3306',
database: 'test',
});
connection.connect();
let addSql = "insert into article (title, author, date) values (?, ?, now())";
let addSqlParams = ['Today is noce', 'Bob'];
connection.query(addSql, addSqlParams, (err, result) => {
if (err) {
throw err;
}
console.log('插入成功');
console.log(result);
});
connection.end();
删
const mysql = require('mysql');
const connection = mysql.createConnection({
host: '127.0.0.1',
user: 'root',
password: 'password',
port: '3306',
database: 'test'
});
connection.connect();
let sql = "delete from article where id = 10";
connection.query(sql, (err, data) => {
if (err) {
throw err;
}
console.log('delete success!');
console.log(data);
});
connection.end();
改
const mysql = require('mysql');
const connection = mysql.createConnection({
host: '127.0.0.1',
user: 'root',
password: 'password',
port: '3306',
database: 'test'
});
connection.connect();
let modSql = "update article set title = ?, author = ? where id like ?";
let modSqlParams = ['今晚学习nodejs', '一波万波', 12];
connection.query(modSql, modSqlParams, (err, data) => {
if (err) {
throw err;
}
console.log('upload success!');
console.log(data)
});
connection.end();
查
const mysql = require('mysql');
const connection = mysql.createConnection({
host: '127.0.0.1',
user: 'root',
password: 'password',
port: '3306',
database: 'test',
});
connection.connect();
let sql = 'SELECT * FROM article';
connection.query(sql, (err, data) => {
if (err) {
console.log('[SELECT ERROR] - ', err.message);
return;
}
console.log(data);
});
connection.end();