[TOC]
> 案例 **數據庫** 采用的是 MySQL
## 1. 基礎連接數據庫
~~~
const mysql = require('mysql');
const connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'pmz.2580',
database: 'test'
});
// 連接數據庫
connection.connect();
const sql = 'SELECT * FROM movies_detail';
connection.query(sql, function (error, results, fields) {
if (error) throw error;
// 從數據庫中查到的數據
console.log('The solution is: ', results[0]);
});
// 關閉連接
connection.end();
~~~
// 輸出結果
