Page 312 - Nodejs 교과서 개정2판

age: 24,
married: false,
comment: '자기소개1',
});

NPEFMT ݽٕীࢲ 6TFS ݽ؛ਸ ࠛ۞৬ create ݫࢲ٘ܳ ࢎਊೞݶ ؾפ׮ খਵ۽ աয়ח ݽٚ ݫࢲ٘ח 6TFS
ݽ؛ਸ ࠛ۞৳׮ח ੹ઁೞী ࣗѐ೤פ׮

ೠ о૑ ઱੄ೡ ੼਷ ؘ੉ఠܳ ֍ਸ ٸ .Z42-੄ ੗ܐഋ੉ ইפۄ द௬ۄ੉ૉ ݽ؛ী ੿੄ೠ ੗ܐഋ؀۽ ֍যঠ
ೠ׮ח Ѫੑפ׮ ੉Ѫ੉ marriedо 0੉ ইפۄ falseੋ ੉ਬੑפ׮ द௬ۄ੉ૉо ঌইࢲ .Z42- ੗ܐഋਵ۽

߄Ըפ׮ ੗ܐഋ੉ա ২࣌ী ࠗ೤ೞ૑ ঋח ؘ੉ఠܳ ֍঻ਸ ٸח द௬ۄ੉ૉо ী۞ܳ ߊࢤदఈפ׮

੉ߣীח ۽਋ܳ ઑഥೞח ௪ܻٜੑפ׮

׮਺਷ VTFST ప੉࠶੄ ݽٚ ؘ੉ఠܳ ઑഥೞח 42-ޙੑפ׮ findAll ݫࢲ٘ܳ ࢎਊೞݶ ؾפ׮

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

׮਺਷ 6TFST ప੉࠶੄ ؘ੉ఠ ೞա݅ оઉয়ח 42-ޙੑפ׮ খਵ۽ ؘ੉ఠܳ ೞա݅ оઉৢ ٸח findOne ݫ

ࢲ٘ܳ ৈ۞ ѐ оઉৢ ٸח findAll ݫࢲ٘ܳ ࢎਊೠ׮Ҋ ࢤпೞݶ ؾפ׮

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

attributes ২࣌ਸ ࢎਊ೧ࢲ ਗೞח ஸۢ݅ оઉৢ ࣻب ੓णפ׮

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

where ২࣌੉ ઑѤٜਸ աৌೞח ২࣌ੑפ׮

SELECT name, age FROM nodejs.users WHERE married = 1 AND age > 30;
const { Op } = require('sequelize');
const { User } = require('../models');