Page 314 - Nodejs 교과서 개정2판

ஸۢ ೞա۽ ೞח ѱ ইפۄ ஸۢ ف ѐ ੉࢚ਵ۽ ೡ ࣻب ੓ӝ ٸޙੑפ׮

׮਺਷ ઑഥೡ ۽਋ ѐࣻܳ ࢸ੿ೞח ߑߨੑפ׮ LIMIT 1ੋ ҃਋ীח findAll ؀न findOne ݫࢲ٘ܳ ࢎਊ೧

ب غ૑݅ ׮਺җ э੉ limit ২࣌ਵ۽ ೡ ࣻب ੓णפ׮

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

limit ২࣌ਵ۽ оמ೤פ׮ OFFSETب ৉द offset ࣘࢿਵ۽ ҳഅೡ ࣻ ੓णפ׮

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

੉ߣীח ۽਋ܳ ࣻ੿ೞח ௪ܻੑפ׮

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

update ݫࢲ٘۽ ࣻ੿ೡ ࣻ ੓णפ׮ ୐ ߣ૩ ੋࣻח ࣻ੿ೡ ղਊ੉Ҋ ف ߣ૩ ੋࣻח যڃ ۽਋ܳ ࣻ੿ೡ૑ী

؀ೠ ઑѤੑפ׮ where ২࣌ী ઑѤٜਸ ੸णפ׮

۽਋ܳ ࢏ઁೞח ௪ܻח ׮਺җ эणפ׮

DELETE FROM nodejs.users WHERE id = 2;
User.destory({