- 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 |
댓글