MySQL
node.js连接MySQL
const mysql = require('mysql');
//配置连接信息
const connection = mysql.createConnection({
host: 'localhost', //主机名
user: 'root', //用户名
password: '123456', //密码
database: 'campus' //连接的数据库
});
//连接数据库
connection.connect();
//配置SQL语句
const sql = `select * from clazz where masterid=(
select id from teacher where teacher.name='robin'
); `
connection.query(
sql,
function (error, results) {
if (error) {
console.error(`SQL语句执行错误`, error);
} else {
console.log(`result:`, results);
}
connection.end()
return
}
);