profile
๐ŸŒƒ๋ธŒ๋กœ์ฝœ๋ฆฌํ•œ ๊ฐœ๋ฐœ์ž๐ŸŒŸ
ํƒœ๊ทธ ๋ชฉ๋ก
์ „์ฒด๋ณด๊ธฐ (99)Sequelize(8)mysql(8)next(7)TROUBLESHOOTING(6)bugfix(6)React(5)๊ณต์‹๋ฌธ์„œ(5)ํ•œ๊ธ€๋ฒˆ์—ญ(5)vscode(5)scroll(4)nextjs(4)CSS(4)winston(4)JavaScript(3)Basic Features@next(3)elasticsearch(3)ubuntu(3)express(3)next@9.3 and up(3)passport(3)settings(2)์šฐ๋ถ„ํˆฌ(2)Nginx(2)ubuntu20.04(2)trobleshooting(2)redis(2)layouts(2)onblur(2)bug(2)style(2)aws(2)๋ฉด์ ‘(2)ESLint(2)google(2)password(2)morgan(2)kibana(2)throttle(2)debounce(2)oAuth(2)Lets Encrypt(1)http(1)connect-flash(1)associations(1)winston-daily-rotate-file(1)์šฐ๋ถ„ํˆฌ20.04(1)S3(1)ํ‚ค๋ฐ”๋‚˜(1)๋ทฐํฌํŠธ(1)image(1)input autocomplet(1)passport local(1)์ด๋ฏธ์ง€(1)FROM(1)multer(1)nodejs(1)๋ฐฐํฌ์„ค์ •(1)validation(1)๋ฒ„์ „fix(1)nodemon(1)lambda(1)์—๋Ÿฌ์‘๋‹ต๋ฐ›๊ธฐ(1)head(1)enospc(1)๋กœ๊ทธ์ธ ์„ฑ๊ณต ํ›„ session ๋ณ€๊ฒฝ๋จ(1)field exclude(1)trouble shooting(1)๋ฐฐ๊ฒฝ์ƒ‰(1)exclude(1)์‚ฌ์šฉ๋ฒ•(1)req.params(1)snap(1)Hostname(1)mailgun(1)๊ฐœ๋…์„ค๋ช…(1)safe mode(1)curl์‚ฌ์šฉ๋ฒ•(1)setting(1)Flex(1)apt-get๊ณผ dpkg์˜ ์ฐจ์ด์ (1)Prettier(1)webpack(1)layout(1)next/image(1)rest API test(1)deploy(1)ec2(1)https(1)Node(1)์ œ๊ฑฐ(1)raw query(1)Saga(1)React.forwardRef(1)facebook(1)req.query(1)Blob(1)tokenizer(1)Authentication@next(1)user settings(1)regex(1)์ธํ„ฐ๋ทฐ(1)build error(1)next@9.x(1)๊ด€๊ณ„(1)media query(1)useRef(1)dpkg(1)analysis(1)axios(1)nvm(1)db์„œ๋ฒ„ ์›๊ฒฉ์ ‘๊ทผ(1)semantic(1)header reaction(1)๋งˆ์šฐ์Šค๋ฐฐํ„ฐ๋ฆฌ์•Œ๋žŒ(1)์ž์ฃผ์‚ฌ์šฉํ•˜๋Š” ๋ช…๋ น์–ด ๋ฐ ์˜ต์…˜(1)erd(1)overflow(1)ubuntu ์–•์€์ง€์‹(1)Multiple(1)critical rendering path(1)Logstash(1)hugo(1)meta(1)infinite scroll(1)๋‹จ์ถ•ํ‚ค(1)AWS es vs elasticsearch(1)error handle(1)nodemailer-mailgun-transport(1)apt-get(1)ssr์˜ต์…˜(1)pm2(1)Migrating to version 4(1)live mode(1)github(1)IntersectionObserver(1)curl(1)shortcut(1)์ด์ง„ํƒ์ƒ‰(1)subquery(1)ignore(1)Nori(1)editor์‚ฌ์šฉ(1)svg(1)styles(1)๋Œ€๋Œ“๊ธ€(1)aws elasticsearch(1)aws es(1)gparted(1)ํƒ์ƒ‰(1)responsive web design(1)autocomplete(1)grid(1)Web fundamentals(1)๋ฐฐ๊ฒฝ์ƒ‰์ œ๊ฑฐ(1)kakao(1)cost(1)session(1)--noHTTPCache(1)ํ„ฐ๋ฏธ๋„(1)association(1)git(1)typescript(1)vim(1)ํ”„๋กœ์„ธ์Šค ์ข…๋ฃŒ(1)association table(1)์šด์˜(1)์•Œ๋žŒ๋„๊ธฐ(1)@next/bundle-analyzer(1)vscode๋‹จ์ถ•ํ‚ค(1)heroku(1)์ธ์ฆ(1)ORDER BY(1)interview(1)forwardRef(1)index์ƒ์„ฑ(1)configure(1)ellipsis(1)terminal(1)passport.js(1)command(1)uml(1)redux saga(1)quickstart(1)sns login(1)
post-thumbnail

webpack troubleshooting

webpack์ด๋ฏธ์ง€์ฒ˜๋Ÿผ webpack์‹คํ–‰์‹œ ์—๋Ÿฌ๊ฐ€ ๋‚œ๋‹ค๋ฉด ์ด๊ฑด webpack.config.js ํŒŒ์ผ์— ์ž‘์„ฑ์ด ์ž˜๋ชป๋œ ๊ฒƒ์ธ์ง€ ํ™•์ธํ•ด์•ผํ•œ๋‹ค.webpack์‹คํ–‰์‹œ ์—๋Ÿฌ

์–ด์ œ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€

๋ฉด์ ‘์งˆ๋ฌธ ์•Œ๊ณ ๋ฆฌ์ฆ˜

์ด์ง„ํƒ์ƒ‰์€ ํƒ์ƒ‰๋ฒ”์œ„๋ฅผ ๋ฐ˜์”ฉ ์ค„์—ฌ์„œ ๊ฒ€์ƒ‰ํ•˜๋Š” ๋ฐฉ๋ฒ•์ด๋‹ค.

4์ผ ์ „
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

๋ฉด์ ‘์งˆ๋ฌธ CRP

์ผ๋‹จ ์ผ๋ฐ˜์ ์ธ CRP ๊ณผ์ •๋ถ€ํ„ฐ ์ด์•ผ๊ธฐ ํ•ด๋ณด์ž.CRPCRP์— ๋Œ€ํ•ด ์ด์•ผ๊ธฐ ํ•˜๊ธฐ์ „์— ๊ฐœ๋…๋ถ€ํ„ฐ ์žก์žDOM (DOCUMENT OBJECT MODEL)์€ ๋ฌธ์„œ๊ฐ์ฒด๋ชจ๋ธ ํŠธ๋ฆฌ๋Š” ์™„์ „ํžˆ ๊ตฌ๋ถ„ ๋ถ„์„๋œ HTML ํŽ˜์ด์ง€๋ฅผ ์˜๋ฏธํ•œ๋‹ค. ์‰ฝ๊ฒŒ ์šฐ๋ฆฌ๋Š” ๊ฐœ๋ฐœ์ž๋„๊ตฌ๋ฅผ ํ†ตํ•ด DOM์„ ๋ณผ์ˆ˜ ์žˆ๋‹ค. ์ด

4์ผ ์ „
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

๋ฉด์ ‘์งˆ๋ฌธ

https://datatracker.ietf.org/doc/html/rfc7230http๋Š” ์ƒํƒœ๋น„์ €์žฅ ์‘์šฉํ”„๋กœ๊ทธ๋žจ๋ ˆ๋ฒจ์˜ ํ”„๋กœํ† ์ฝœ์ด๋ผ๊ณ  ์ด๋ฏธ ์ •์˜ ๋˜์–ด์žˆ๋‹ค. ๋”ฐ๋ผ์„œ ์ ˆ๋Œ€ statefulํ•  ์ˆ˜ ์—†๋‹ค.http๋Š” ์ ˆ๋Œ€ stateful์ด ๋  ์ˆ˜ ์—†๋‹ค.https&#x3A

4์ผ ์ „
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

๊ฐœ๋ฐœ ์ดˆ๊ธฐ ์„ธํŒ…

๊ฐœ๋ฐœ์„ ์ง„ํ–‰ํ•˜๊ธฐ ์•ž์„œ ํ•ญ์ƒ ํ”„๋กœ์ ํŠธ๋งˆ๋‹ค ์„ธํŒ…์„ ํ•ด๋‘๋„๋ก ํ•˜์ž.eslint์™€ prettier์ธ๋ฐ, ์ „์—ญ์œผ๋กœ ํ”ผ์”จ์— ์„ค์น˜๊ฐ€ ๋˜์–ด ์žˆ์„ ์ˆ˜ ์žˆ์ง€๋งŒ ํ”„๋กœ์ ํŠธ๋งˆ๋‹ค ๋‹ค๋ฅธ ์„ค์ •์ด ๊ฐ€๋ฏธ๋  ํ•„์š”๊ฐ€ ์žˆ๊ธฐ ๋•Œ๋ฌธ์— ์ด๋ ‡๊ฒŒ ํ”„๋กœ์ ํŠธ๋ณ„๋กœ ๋”ฐ๋กœ๋”ฐ๋กœ ์„ธํŒ…์„ ํ•˜๋Š”๊ฒŒ ์ข‹๋‹ค.eslint : ์ฝ”๋“œ ํ’ˆ์งˆ

6์ผ ์ „
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

Web Fundamentals

Web Fundamentals๋ผ๋Š” ์ฃผ์ œ๋กœ ์ž‘์„ฑ๋œ ๋ฌธ์„œ๋“ค์ด ์žˆ์–ด์„œ ์ฐจ๊ทผ์ฐจ๊ทผ ์ผ์–ด๋ณด๋ฉด์„œ ํ•„์š”ํ•œ ๋ถ€๋ถ„๋งŒ ์ •๋ฆฌํ•ด์„œ ํ‘œํ˜„์— ์ต์ˆ™ํ•ด์ง€๋ ค๊ณ  ํ•œ๋‹ค. ๐Ÿฆธ๐Ÿป๐Ÿฆธ๐Ÿป ์šฐ์„  Performance๋ถ€ํ„ฐweb_fundamentals์›๋ฌธ๊ธ€๋งํฌ์‚ฌ์šฉ์ž๊ฐ€ ๊ทธ๋ž˜์•ผ ๋” ๋Š˜๊ณ  ๋งŽ์ด ์‚ฌ์šฉํ•˜๋‹ˆ๊นŒ. ๊ทธ๋ž˜์„œ ๋”ฐ

2021๋…„ 7์›” 19์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

hugo static file not applied

hugo๋ฅผ ๋กœ์ปฌ์—์„œ ๋นŒ๋“œํ•˜๊ณ  ํ…Œ์ŠคํŠธ ํ•˜๋Š”๋ฐ, static ํŒŒ์ผ๋“ค์ด ์ ์šฉ์ด ์•ˆ๋˜๋Š” ๊ฒฝ์šฐ๊ฐ€ ์žˆ๋‹ค. ์ด๋Ÿด๋•Œ๋Š” ๋ธŒ๋ผ์šฐ์ €์—์„œ ๊ฐ•๋ ฅ์บ์‹œ์ง€์šฐ๊ธฐ๋ฅผ ์‹œ๋„ํ•˜๊ฑฐ๋‚˜ ์„œ๋ฒ„์‹œ๋™ํ•  ๋•Œ ์˜ต์…˜์„ ๊ฑธ์–ด์ฃผ๋ฉด ๋œ๋‹ค.

2021๋…„ 7์›” 19์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

๊ธ€์ž๊ธธ๋•Œ ... ellipsis ๋งŒ๋“ค๊ธฐ

์ผ๋ฐ˜์ ์œผ๋กœ ๊ทธ๋ƒฅ ํ•œ์ค„์งœ๋ฆฌ ellipsis๋Š” ๊ฐ„๋‹จํ•˜๋‹ค์ด๋ ‡๊ฒŒ ํ•˜๋ฉด ๋œ๋‹ค.ํ•˜์ง€๋งŒ ๋งŒ์•ฝ ์—ฌ๋Ÿฌ์ค„์˜ ๊ธด ๋ฌธ์žฅ๋“ค์˜ ๋ช‡๋ฒˆ์งธ ์ค„๋ถ€ํ„ฐ ...์„ ์ฃผ๊ณ  ์‹ถ๋‹ค๋ฉด ์•„๋ž˜์™€ ๊ฐ™์ด ํ•˜๋ฉด ๋œ๋‹ค.\-webkit-line-clamp๊ฐ€ ๋ช‡๋ฒˆ์งธ์— ellipsis๋ฅผ ์ค„ ๊ฒƒ์ธ์ง€ ํŒ๋‹จํ•ด์ค€๋‹ค.ํŠน์ • ๊ธ€์ž์ˆ˜์— ๋”ฐ๋ผ ๋งž

2021๋…„ 7์›” 15์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

AWS Lambda

Lambda๋Š” ์„œ๋ฒ„๋ฆฌ์Šค ์ปดํ“จํŒ… ์„œ๋น„์Šค์ด๋‹ค. zip์ด๋‚˜ ์ปจํ…Œ์ด๋„ˆ ์ด๋ฏธ์ง€๋กœ ์—…๋กœ๋“œ๋งŒ ํ•˜๋ฉด Lambda๋Š” ๋ชจ๋“  ์œ ํ˜•์˜ ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์ด๋‚˜ ๋ฐฑ์—”๋“œ์„œ๋น„์Šค์— ์ž๋™์œผ๋กœ ์ด๋ฒคํŠธ๋ฅผ ๊ฐ์ง€ํ•ด์„œ ์‹คํ–‰ํ•  ์ˆ˜ ์žˆ๋‹ค. ์ด๋ฒˆ์— ์ฒ˜์Œ ์‹œ๋„ํ•˜๋Š” Lambda๋Š” ๋กœ์ปฌ์—์„œ zip์„ ๋งŒ๋“ค์–ด์„œ awscli๋ฅผ ์ด์šฉ

2021๋…„ 7์›” 15์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

multer๋กœ S3 ์—…๋กœ๋“œ

โ„น๏ธ multer๋ฅผ ์‚ฌ์šฉ์‹œ ๊ผญ ๋งค์นญ์„ ์‹œ์ผœ์ค˜์•ผํ•˜๋Š” ๊ฒƒ 2๊ฐ€์ง€1\. FormData์˜ ํ‚ค๊ฐ’(์—ฌ๊ธฐ์„  image๋กœ ํ•จ)์„ multer.single('image')์™€ ๊ฐ™์ด ์ผ์น˜์‹œ์ผœ์ฃผ๋Š”๊ฒƒ2\. ์š”์ฒญ์‹œ header์˜ Content-type์„ multipart/form-data\`

2021๋…„ 7์›” 15์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

M x N association table ์ปฌ๋Ÿผ ์ถ”๊ฐ€ ๋ฐ ์ˆ˜์ •

M x N Association Table์—๋Š” ๊ธฐ๋ณธ์ ์œผ๋กœ ์ฐธ์กฐํ•œ ๋ชจ๋ธ์˜ ๊ธฐ๋ณธํ‚ค๋งŒ ์ปฌ๋Ÿผ์œผ๋กœ ๋“ค์–ด๊ฐ€๋Š”๋ฐ, ์ถ”๊ฐ€์ ์œผ๋กœ ์ปฌ๋Ÿผ์„ ๋„ฃ๊ณ  ์‹ถ๋‹ค๋ฉด ๋ชจ๋ธ์„ ๋งŒ๋“ค์–ด์„œ ๋งŒ๋“  ๋ชจ๋ธ์„ through๋กœ ์ถ”๊ฐ€ํ•˜๋ฉด ๋œ๋‹ค.If you want additional attributes in your j

2021๋…„ 7์›” 13์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

next์—์„œ Head ์„ค์ •

next์—์„œ \_app.js ์— Head๋ฅผ ์„ค์ •ํ•˜๋Š” ๋ฐฉ๋ฒ•์€ ์•„๋ž˜์™€ ๊ฐ™๋‹ค.๊ณต์‹ํŽ˜์ด์ง€์—์„œ๋Š” component์™€ pages์— ์„ค์ •ํ•˜๋ผ๊ณ  ๋˜์–ด ์žˆ์ง€๋งŒ ๋ฐ˜๋ณต์ ์ธ ์ž‘์—…์„ ํ”ผํ•˜๊ธฐ ์œ„ํ•ด์„œ \_app.js์— ์ถ”๊ฐ€ํ•จ.Unable to use Head component with meta

2021๋…„ 7์›” 9์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

aws db์„œ๋ฒ„ ์ ‘๊ทผํ•˜๊ธฐ

aws db ์ธ์Šคํ„ด์Šค ์ƒ์„ฑ์™„๋ฃŒaws security group setํ•˜๊ธฐmysql bind-address ์ˆ˜์ •์™ธ๋ถ€์—์„œ ์ ‘๊ทผํ•  ๊ณ„์ • ๋งŒ๋“ค๊ณ  ๊ถŒํ•œ ๋ถ€์—ฌํ•˜๊ณ  ๋กœ์ปฌ์—์„œ ์ ‘๊ทผํ•˜๊ธฐ์ด๋ฏธ aws์— db ์ธ์Šคํ„ด์Šค๋ฅผ ์ƒ์„ฑํ–ˆ๋‹ค ๊ฐ€์ •ํ•˜๊ธฐ ๋•Œ๋ฌธ์— 1๋ฒˆ์€ ์ƒ๋žต2-1. ์•„๋ž˜์ฒ˜๋Ÿผ ํ•ด๋‹น ์ธ์Šคํ„ด์Šค ์ƒ

2021๋…„ 7์›” 9์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

next build์‹œ eslint ์—๋Ÿฌ

ํŠน๋ณ„ํ•œ build ์‹คํŒจ ์—๋Ÿฌ๊ฐ€ ์•ˆ๋ณด์ด๋Š”๋ฐ eslint์—๋Ÿฌ๋งŒ ๋ง‰ ๋œจ๋‹ค๊ฐ€ ์‹คํŒจํ•˜๋Š” ๊ฒฝ์šฐ์—” eslint๋•Œ๋ฌธ์— ๋นŒ๋“œ๊ฐ€ ์‹คํŒจํ–ˆ๋‹ค๊ณ  ๋ณด๋ฉด ๋œ๋‹ค. ์ด๋•Œ๋Š” ๋นŒ๋“œ์‹œ eslint๋ฅผ ๋ฌด์‹œํ•˜๋Š” ์˜ต์…˜์„ ๋„ฃ์–ด์ค˜์•ผ ๋นŒ๋“œ๊ฐ€ ๋œ๋‹ค.์•„๋ž˜์™€ ๊ฐ™์ด next.config.js์— ๋นŒ๋“œ ๋ฌด์‹œ ์„ค์ •์„ ๋„ฃ์–ด์ฃผ๋ฉด

2021๋…„ 7์›” 8์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

OAuth์šฉ ๋กœ๊ทธ์ธ ์•ฑ ๋งŒ๋“ค๊ธฐ

OAuth๋ฅผ ํ™œ์šฉํ•˜๊ธฐ ์œ„ํ•ด์„œ๋Š” ๊ฐ ์ œ๊ณต์ž development ์‚ฌ์ดํŠธ์—์„œ ๋กœ๊ทธ์ธ์šฉ ์•ฑ์„ ๋งŒ๋“ค์–ด์•ผํ•œ๋‹ค.๋ฐฑ์—”๋“œ์—์„œ๋Š” ์ด ๋กœ๊ทธ์ธ์šฉ ์•ฑ์— ํ—ˆ์šฉ๋œ ํ† ํฐ๊ณผ ํ•จ๊ป˜ ์š”์ฒญ์„ ๋ณด๋‚ด๋ฉด ์ œ๊ณต์ž๊ฐ€ ๊ฐ€์ง€๊ณ ์žˆ๋Š” ์‚ฌ์šฉ์ž์˜ ์ •๋ณด๋ฅผ ๋™์˜ํ•˜์— ์ „๋‹ฌ๋ฐ›์„ ์ˆ˜ ์žˆ๋‹ค. ์•„๋ž˜ ๋ณธ๋ฌธ์—๋Š” github, kakao,

2021๋…„ 7์›” 8์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

REST API test on vscode

vscode๋กœ rest api๋ฅผ ํ…Œ์ŠคํŠธ ํ•  ์ˆ˜ ์žˆ๋‹ค. postman๊ณผ ๊ฐ™์€ ๋‹ค์–‘ํ•œ ๊ธฐ๋Šฅ์ด ์žˆ๋Š”์ง€ ์—ฌ๋ถ€๋Š” ์ž˜ ๋ชจ๋ฅด๊ฒ ์ง€๋งŒ, ๋ผ์ดํŠธํ•˜๊ฒŒ ์‚ฌ์šฉํ•˜๋Š”๊ฑธ ์„ ํ˜ธํ•˜๋Š” ์‚ฌ๋žŒ๋“ค์—๊ฒ ์ด๋ฐฉ์‹์ด ํ›จ์”ฌ ํŽธํ•  ๊ฑฐ๋ผ๊ณ  ๋ณธ๋‹ค.vscode๋กœ rest api ํ…Œ์ŠคํŠธ๋ฅผ ํ•˜๊ธฐ ์œ„ํ•ด์„œ๋Š” ๋‹ค์Œ extenstio

2021๋…„ 7์›” 7์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

๋‚ด์™ธ๋ถ€ ๊ตฌ๋ถ„, onBlur on react

next@10.1.3react@17.0.3Focus๊ด€๋ จํ•ด์„œ ์ผ๋ฐ˜์ ์œผ๋กœ js์—์„œ๋Š” focusin, focusout์ด๋ฒคํŠธ๊ฐ€ ์žˆ๊ณ  ๋ณ„๋„๋กœ blur๊ด€๋ จ์ด๋ฒคํŠธ๊ฐ€ ์žˆ๋‹ค. ํ•˜์ง€๋งŒ react์—์„œ๋Š” onFocus, onBlur ๋‘๊ฐ€์ง€๋งŒ ์žˆ๋‹ค. ๋”ฐ๋ผ์„œ ํฌ์ปค์Šค๊ฐ€ ๋– ๋‚จ์„ ํ‘œํ˜„ํ•˜๊ณ ์ž ํ•  ๋•Œ๋Š”

2021๋…„ 7์›” 2์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

Sequelize raw query

Sequelize๋Š” ๋น„๊ต์  ๋‹จ์ˆœํ•œ select์ ˆ์„ ์กฐํšŒํ•œ๋‹ค๊ณ  ํ• ๋•Œ๋Š” ๋งค์šฐ ๊ฐ„ํŽธํ•˜๋‹ค.ํ•˜์ง€๋งŒ subquery๋ฅผ from์ ˆ์—์„œ ๋งŒ๋“ค์–ด์„œ ํ•˜๊ฑฐ๋‚˜, ํŠน์ •ํ•œ ์กฐ๊ฑด์ด ํ•„์š”ํ•˜๋Š” ๋“ฑ ๋ฐ์ดํ„ฐ ์กฐํšŒ๊ฐ€ ์กฐ๊ธˆ ๋ณต์žกํ•ด์ง€๋ฉด sequelize๋ฅผ ์‚ฌ์šฉํ•˜๋Š” ๊ฒƒ์ด ํ›จ์”ฌ ๋” ํž˜๋“ค์–ด์ง€๋Š” ๊ฒƒ ๊ฐ™๋‹ค. ์ผ๋‹จ ํ•ด

2021๋…„ 6์›” 30์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

Subquery in FROM Clause

sequelize๋กœ subquery๋กœ from์ ˆ ๋‚ด๋ถ€๋ฅผ ํ‘œํ˜„ํ•˜๊ณ  ์‹ถ์—ˆ๋Š”๋ฐ, ๊ฐ–์€ ๋ฐฉ๋ฒ•์„ ๋‹ค ํ•ด๋ด๋„ ์•ˆ๋จ...์ฐพ์•„๋ณด๋‹ˆ ์ง€์› ์•ˆํ•จ...ใ… Subquery in FROM Clause

2021๋…„ 6์›” 30์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
post-thumbnail

sequelize order multiple times

MySQL : 8.0.23sequelize: 6.6.2node: 14.15.1sequelize๋ฅผ ์‚ฌ์šฉํ•˜๋ฉด ํŽธํ•˜๊ธด ํ•œ๋ฐ, orderby ํ•˜๊ฑฐ๋‚˜ join์‹œ ์ข€ ์ œ์•ฝ์„ ๊ฐ€ํ•˜๋ ค๊ณ  ํ•˜๋Š” ๋“ฑ์˜ ๊ธฐ๋Šฅ์„ ์ฐพ์œผ๋ ค๊ณ  ํ•˜๋ฉด ๋ถˆํŽธํ• ๋•Œ๊ฐ€ ์ข…์ข… ์žˆ๋‹ค. ์ด๋ฒˆ์—” order by ๋•Œ๋ฌธ์— ์ข€ ๋ถˆํŽธํ–ˆ๋‹ค

2021๋…„ 6์›” 29์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€