node.js 다중 쿼리
펌 스크립트
2019-03-25 12:59
connection 생성 시 multipleStatements: true 추가
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | var connection = mysql.createConnection({ user: 'root', password: '*****', database: 'test', multipleStatements: true//추가 }); //table name: nembers, statistics connection.query('SELECT * FROM nembers; SELECT * FROM statistics', function(error, results) { if (error) { console.log(error); } else { console.log(results[0]); console.log(results[1]); } }); | cs |