MySQL & Node.js

[xgqfrms]

MySQL & Node.js

Node.js

https://www.w3schools.com/nodejs/nodejs_mysql.asp

$ yarn add mysql

$ npm i mysql

https://www.w3schools.com/nodejs/nodejs_raspberrypi.asp

MySQL

https://www.w3schools.com/sql/sql_ref_mysql.asp

[xgqfrms]

BFF

Backends For Frontends

https://developer.ibm.com/technologies/microservices/patterns/create-backend-for-frontend-application-architecture/

[xgqfrms]

https://www.npmjs.com/package/mysql

这是mysql的node.js驱动程序。它是用JavaScript编写的，不需要编译，并且已获得MIT的100％许可。

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'me',
  password : 'secret',
  database : 'my_db'
});

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.end();