const mysql = require('mysql');
const connection = mysql.createConnection({
host:'localhost',
user:'root',
password:'admin123',
database:'practice',
port:'3306'
});
connection.connect();
//#1
connection.query('SELECT * FROM practiceTable',(error,results, fields)=>{
if(error) throw error;
console.log('#1');
console.log(results);
})
//#2
connection.query('SELECT number,genre ,name ,writer ,releasedate FROM practiceTable',(error,results, fields)=>{
if(error) throw error;
console.log('#2');
console.log(results);
})
//#3
connection.query('SELECT * FROM practiceTable WHERE genre =\'action\'',(error,results, fields)=>{
if(error) throw error;
console.log('#3');
console.log(results);
})
//#4
connection.query('SELECT * FROM practiceTable WHERE genre =\'action\' OR genre=\'romance\'',(error,results, fields)=>{
if(error) throw error;
console.log('#4');
console.log(results);
})
//#5
connection.query('SELECT * FROM practiceTable WHERE releasedate LIKE \'2021%\'',(error,results, fields)=>{
if(error) throw error;
console.log('#5');
console.log(results);
})
//#6
connection.query('SELECT number, genre, name, writer, releasedate from practiceTable order by releasedate',(error,results, fields)=>{
if(error) throw error;
console.log('#6');
console.log(results);
})
//#7
connection.query('SELECT number, genre, name, writer, releasedate from practiceTable order by releasedate desc',(error,results, fields)=>{
if(error) throw error;
console.log('#7');
console.log(results);
})
콘솔 결과값
수정하기(update)
// mysql 모듈 사용
const mysql = require('mysql');
// 연결할 DB 정보입력
const connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'admin123',
database: 'practice',
port: '3306',
});
// 데이터베이스 연결
connection.connect();
// Update 쿼리문 사용, 한 필드 수정(genre 변경)
connection.query("UPDATE practiceTable SET genre = 'comic' WHERE number = 2 AND name = 'First Love';"
, (error, results, fields) => {
if (error) throw error;
console.log(results);
});
// Select 쿼리문 사용
connection.query('SELECT * FROM practiceTable', (error, results, fields) => {
if (error) throw error;
console.log(results);
});
// 연결 종료
connection.end();
콘솔값이렇게 찍힘
삭제하기(delete)
// mysql 모듈 사용
const mysql = require('mysql');
// 연결할 DB 정보입력
const connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'admin123',
database: 'practice',
port: '3306',
});
// 데이터베이스 연결
connection.connect();
// Delete 쿼리문 사용
connection.query("DELETE FROM practiceTable WHERE number = 2 AND writer = 'B.unknown';", (error, results, fields) => {
if (error) throw error;
console.log(results);
});
// Select 쿼리문 사용
connection.query('SELECT * FROM practiceTable', (error, results, fields) => {
if (error) throw error;
console.log(results);
});
// 연결 종료
connection.end();
콘솔창
결과
'나혼자공부시간(평일저녁,주말,휴일때)' 카테고리의 다른 글
NODE.JS:게시판만들기(생성:create, 수정:Modify, 삭제:delete) (0) | 2023.08.23 |
---|---|
NODE.JS:크롤러활용 (0) | 2023.08.23 |
node.js:mySQL(MariaDB) 연결 연동하기(mySQL 맥에서 path 경로 해주는법)/database 테이블(table) create구문 / insert구문 (0) | 2023.08.22 |
mode-schedule모듈 (0) | 2023.08.22 |
(java10 질문 물어봐)express 모듈-미들웨어/body parser미들웨어/router/morgan/winston/combine(colorize(),simple()),timestamp()/connect-multiparty/express-session (0) | 2023.08.21 |