如何在节点JS中编写长MySQL查询
如何在节点JS中编写长MySQL查询
提问于 2018-07-26 04:44:48
如何在多行上编写长的MySQL查询，而不是非常长的一行，以便于阅读和修改。我只知道这样写它们：
app.get('/example', function(req, res){
x = 'SELECT doctors_schedule.*, employees.employee_name, doctors.degree FROM doctors_schedule JOIN employees ON employees.employee_id = doctors_schedule.doctor_id JOIN doctors ON doctors.doctor_id = employees.employee_id ORDER BY employees.employee_id';
connection.query(x, function(error, rows, fields){
if(error){console.log(error);}
res.json(rows);
});
});回答 2
Stack Overflow用户
回答已采纳
发布于 2018-07-26 04:49:16
使用template literals (模板字符串)：
app.get('/example', function(req, res){
const x = `SELECT doctors_schedule.*, employees.employee_name, doctors.degree
FROM doctors_schedule
JOIN employees ON employees.employee_id = doctors_schedule.doctor_id
JOIN doctors ON doctors.doctor_id = employees.employee_id
ORDER BY employees.employee_id`;
connection.query(x, function(error, rows, fields){
if(error){
console.log(error);
}
res.json(rows);
});
});此功能从Node.js v.4.0.0开始可用。
Stack Overflow用户
发布于 2018-07-26 04:49:25
es6给我们带来了模板文字。您可以使用反引号，并且可以轻松地跨多行。阅读有关此here的更多信息
app.get('/example', function(req, res){
x = `
SELECT doctors_schedule.*, employees.employee_name, doctors.degree
FROM doctors_schedule
JOIN employees ON employees.employee_id = doctors_schedule.doctor_id
JOIN doctors ON doctors.doctor_id = employees.employee_id
ORDER BY employees.employee_id
`;
connection.query(x, function(error, rows, fields){
if(error){console.log(error);}
res.json(rows);
});
});页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/51527377
复制相关文章
相似问题