본문 바로가기
SQL

MYSQL - NodeJS 2.1

by 집요한 개발자 2021. 4. 8.

- npm i mysql2

var express = require('express')

var app = express()

var router = express.Router()

var path = require('path')

var mysql = require('mysql2');

var passport = require('passport');

const { Router } = require('express');

var LocalStrategy = require('passport-local').Strategy

 

var connection = mysql.createConnection({

    host: 'localhost',

    port: 3306,

    user: 'root',

    password: 'root',

    database: 'nodejs'

});

connection.connect();

 

router.get('/', function (req, res) {

    var responseData = {};

    var query = connection.query('select event from sports', function (err, rows) {

        if (err) throw err;

        if (rows.length) {

            console.log(rows);

            responseData.result = 1;

            responseData.data = rows;

        } else {

            responseData.result = "0";

        }

        res.json(responseData)

    })

})

 

module.exports = router;

'SQL' 카테고리의 다른 글

Mysql 설치시 server has failed 에러 해결 방법 중 하나  (0) 2021.12.27
MYSQL - NodeJS 4  (0) 2021.04.09
MYSQL - NodeJS 3  (0) 2021.04.08
MYSQL - NodeJS 2  (0) 2021.04.08
MYSQL - NodeJS  (0) 2021.04.07

댓글