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
| const mysql = require("mysql2/promise")
|
| const {host, port, user, database, password} = require("./settings").db
|
| /////////////////////////////////////////////////////////////////////////
|
| run()
| .then(console.log)
| .catch(console.error)
| .finally(process.exit)
|
| /////////////////////////////////////////////////////////////////////////
|
| async function run () {
| // Create the connection to database
| console.log(111111111111,mysql)
| const connection = await mysql.createConnection({
| host,
| port,
| database,
| user,
| password,
| })
|
| // A simple SELECT query
| try {
| const [results, fields] = await connection.query(
| `SELECT ud.* FROM ilias.usr_data AS ud WHERE login = '242424'`
| )
|
| console.log(results) // results contains rows returned by server
| console.log(fields) // fields contains extra meta data about results, if available
| } catch (err) {
| console.log(err)
| }
| }
|
|
