TravelAgencyProject/models.js at master · bhavya14/TravelAgencyProject · GitHub

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
31
32
33
34
35
36
37
38
const mysql = require('mysql2');

const connection = mysql.createConnection({
    host: 'localhost',
    user: 'a',
    database: 'test',
    password: 'a'
})

// connection.query(
//     "CREATE TABLE user(a int);",
//     function (err, results) {
//         console.log(err)
//         console.log(results)
//
//     }
// )

module.exports = connection;

// connection.query(
//     "Insert into user values(6);",
//     function (err, results, fields) {
//         console.log(err)
//         console.log(results)
//         console.log(fields)
//
//     }
// )
//
// connection.query(
//     "Select * from user;",
//     function (err, results) {
//         console.log(err)
//         console.log(results)
//
//     }
// )