-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtest.js
30 lines (25 loc) · 853 Bytes
/
test.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
var mysql = require('mysql');
var connection = mysql.createConnection({
host: 'localhost',
user: 'covid',
password: 'admin',
port: '3306',
database: 'covidhouse'
});
// connection.connect();
// var sql = 'select * from test';
// connection.query(sql, function(err, result) {
// if (err) {
// console.log('[SELECT ERROR] - ', err.message);
// return;
// }
// console.log('--------------------------SELECT----------------------------');
// console.log(result);
// console.log('------------------------------------------------------------\n\n');
// });
// connection.end();
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);
});