개발블로그 개발블로그

뷰 select한 것을 보는 가상 테이블 create view view_products as select name, price, amount from products; SELECT * FROM exam11.view_products; 이너조인 create view view_purchases as select purchases.member_email, products.name, purchases.date from products inner join purchases on products.id = purchases.product_id; select * from view_purchases; 트랜잭션 오토커밋 여부 확인 SELECT @@AUTOCOMMIT; SET AUTOCOMMIT = TRUE; //오토커밋 설..

mysql 설치 mysql workbench 설치 https://dev.mysql.com/downloads/workbench/ MySQL :: Download MySQL Workbench Select Operating System: Select Operating System… Microsoft Windows Ubuntu Linux Red Hat Enterprise Linux / Oracle Linux Fedora macOS Source Code Select OS Version: All Windows (x86, 64-bit) Recommended Download: Other Downloads: Windows (x86, 64-bit), M dev.mysql.com 스키마 만들기 exam11 테이블 생성 멤버..

0. 데이터 베이스, 테이블, 데이터 추가 1. express-sequelize 프로젝트 생성 npm init -y npm i express npm i mysql npm i sequelize npm i sequelize-auto npm i sequelize-cli app.js 생성 const express = require('express'); const userRouter = require(__dirname + '/routes/api'); const app = express(); const port = 3000; app.use(express.json()) app.use('/api', userRouter) app.get('/', (req, res) => { res.send(); }) app.listen(..

Sequelize ORM으로 분류됨 npm init -y app.js 생성 npm i mysql2 npm i nodemon npm i express npm i sequelize -g npm i sequelize-cli -g npm i sequelize-auto -g app.js const express = require('express'); const app = express(); const { Sequelize } = require('sequelize'); const sequelize = new Sequelize('mysql', 'root', '1234', { host: 'localhost', dialect: 'mysql' }); app.get('/', (req, res) => { res.send('h..

const express = require('express'); const app = express(); const port = 3000; const mysql = require('mysql2'); app.use(express.json()) const connection = mysql.createConnection({ host : '127.0.0.1', port : '3307', user : 'root', password : '1234', database : 'nodejs' }); app.get('/', (req, res) => { res.end('hello express'); }); app.get('/:id', (req, res) => { const id = req.params.id; const que..

UPDATE(수정) UPDATE 테이블명 SET 컬럼명 = '바꿀내용' where 바꿀 대상을 취득하는 조건식; //ex) where id = 2; DELETE (삭제) DELETE FROM 테이블 WHERE 조건식; node.js mysql 모듈 1. mysql https://www.npmjs.com/package/mysql mysql A node.js driver for mysql. It is written in JavaScript, does not require compiling, and is 100% MIT licensed. www.npmjs.com 2. mysql2 https://www.npmjs.com/package/mysql2 mysql2 fast mysql driver. Implements..

DB Mysql은 관계형 데이터베이스 몽고디비는 NoSQL 관령성을가지며 중복이 없는 데이터들의 집합 데이터베이스를 관리하는 시스템 DBMS mysql 다운로드 https://dev.mysql.com/downloads/installer/ MySQL :: Download MySQL Installer Select Operating System: Select Operating System… Microsoft Windows Select OS Version: All Windows (x86, 32-bit) Windows (x86, 32-bit), MSI Installer 8.0.25 2.4M (mysql-installer-web-community-8.0.25.0.msi) MD5: 7f64b7ca2c526c35991..