2. nodejs 라이브러리 sequelize의 쿼리 명령문

1. Insert 문

SQL문법

INSERT INTO nodejs.users (name, age, married, comment) VALUES ('zero', 24, 0, '자기소개1');

sequelize 문법

const { User } = require('../models')
User.create({
name: 'zero',
age: 24,
married: false,
comment: '자기소개1',
});

 

이하 아래부터는 위는 SQL문 아래는 seq문법이다.

 

 

 

- SELECT * FROM nodejs.users; - User.findALL({});

 

- SELECT * FROM nodejs.users LIMIT 1; - User.findOne({});

 

- SELECT name, married FROM nodejs.users; - User.findALL({   attributes: ['name', 'married'], });

 

- SELECT name, age FROM nodejs.users WHERE married =1 AND age > 30;   - const { User, Sequelize : {Op}} = require('../models'); User.findAll({   attributes: ['name', 'age'], where: {   married: 1, age: { [Op.gt]: 30 }, }, });

 

- SELECT id, name FROM users ORDER BY age DESC; - User.findAll({   attributes: ['id', 'name'], order: [[ 'age', 'DESC']], });

 

- UPDATE nodejs.users SET comment = '바꿀 내용' WHERE id = 2; - User.update({   comment: '바꿀 내용', }, {   where : { id : 2 }, });

 

- DELETE FROM nodejs.users WHERE id = 2; - User.destroy({  where: { id : 2}, });