๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
728x90
๋ฐ˜์‘ํ˜•

์ „์ฒด ๊ธ€121

SQL ON UPDATE CASCADE : ์™ธ๋ž˜ํ‚ค ์—ฐ๊ฒฐ ์‹œ ๋™๊ธฐํ™” ๐Ÿ”Ž SQL DDL ๊ตฌ์„ฑํ•˜๋‹ค๊ฐ€ ref๋กœ ์—ฐ๊ฒฐ๋œ key์— ํ•ด๋‹น ์†์„ฑ ์˜๋ฌธ ON UPDATE CASCADEON UPDATE CASCADE๋Š” ์™ธ๋ž˜ ํ‚ค ์ œ์•ฝ ์กฐ๊ฑด(Foreign Key Constraint)์—์„œ ์‚ฌ์šฉ๋˜๋Š” ์˜ต์…˜์œผ๋กœ, ์ฐธ์กฐ๋˜๋Š” ๋ถ€๋ชจ ํ…Œ์ด๋ธ”์˜ ๊ธฐ๋ณธ ํ‚ค(Primary Key) ๊ฐ’์ด ๋ณ€๊ฒฝ๋  ๋•Œ ์ž๋™์œผ๋กœ ์ž์‹ ํ…Œ์ด๋ธ”์˜ ์™ธ๋ž˜ ํ‚ค(Foreign Key) ๊ฐ’๋„ ํ•จ๊ป˜ ์—…๋ฐ์ดํŠธ๋˜๋„๋ก ํ•˜๋Š” ์„ค์ •์ด๋‹ค. ์ด๋ฅผ ํ†ตํ•ด ์ฐธ์กฐ ๋ฌด๊ฒฐ์„ฑ(Referential Integrity)์„ ์œ ์ง€ํ•  ์ˆ˜ ์žˆ๋‹ค.๋‹ค์Œ์€ ์ด๋ฅผ ์„ค๋ช…ํ•˜๋Š” ์˜ˆ์‹œ์™€ ํ•จ๊ป˜ ๋ช‡ ๊ฐ€์ง€ ์ž์„ธํ•œ ๋‚ด์šฉ์„ ํฌํ•จํ•œ ์„ค๋ช…์ด๋‹ค:์˜ˆ์‹œ๋จผ์ €, ๋‘ ํ…Œ์ด๋ธ” MEMBER์™€ STORE๊ฐ€ ์žˆ๋‹ค๊ณ  ๊ฐ€์ •ํ•œ๋‹ค:CREATE TABLE MEMBER ( id INT PRIMARY KEY, name VARC.. 2024. 6. 20.
NEXT.js import NextApiRequest / NextRequest ์ฐจ์ด์  Q. import { NextApiRequest, NextApiResponse } from "next"import { NextRequest, NextResponse } from "next/server" import ์ฐจ์ด?  CAHT.Next.js์˜ app ๋””๋ ‰ํ† ๋ฆฌ์—์„œ ์‚ฌ์šฉํ•˜๋Š” ๋ผ์šฐํŒ… ๋ฐฉ์‹๊ณผ pages ๋””๋ ‰ํ† ๋ฆฌ์—์„œ ์‚ฌ์šฉํ•˜๋Š” ๋ผ์šฐํŒ… ๋ฐฉ์‹์€ ์•ฝ๊ฐ„ ๋‹ค๋ฅด๋‹ค. ๊ฐ ๋ผ์šฐํŒ… ๋ฐฉ์‹์—์„œ ์‚ฌ์šฉ๋˜๋Š” import ๋ฌธ๋„ ๋‹ค๋ฅด๋‹ค. ์ด ๋‘ ๊ฐœ์˜ import ์ฐจ์ด์— ๋Œ€ํ•ด ์„ค๋ช…ํ•˜๊ฒ ๋‹ค.1. NextApiRequest์™€ NextApiResponse (Pages ๋””๋ ‰ํ† ๋ฆฌ)NextApiRequest์™€ NextApiResponse๋Š” Next.js์˜ pages ๋””๋ ‰ํ† ๋ฆฌ์—์„œ API ๋ผ์šฐํŠธ๋ฅผ ์ •์˜ํ•  ๋•Œ ์‚ฌ์šฉ๋œ๋‹ค. ์ด ๋ฐฉ์‹์€ Next.js 12 ์ด์ „๋ถ€.. 2024. 6. 14.
NํšŒ๋… : ์ƒํ™œ์ฝ”๋”ฉ Next.js https://youtube.com/playlist?list=PLuHgQVnccGMCwxXsQuEoG-JJ7RlwtNdwJ&si=4NpjJb1WUzVj8ZFE Next.js 13 www.youtube.comapp routing /[id]๋กœ ์ด๋ฃจ์–ด์ง„ ๊ฒฝ๋กœ์ธ ๊ฒฝ์šฐ props.params.id๋กœ ๋‹ค์ด๋‚˜๋ฏน ๋ผ์šฐํŒ…์œผ๋กœ ๋„˜๊ฒจ์ค€ ๊ฐ’์„ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋‹ค. 2024. 6. 14.
์ฝ”๋”ฉ์• ํ”Œ NEXT https://youtu.be/PCkiz2GUFg8?si=aLJ6cTEZbRWr0ts4์ฃผ๊ธฐ์ ์œผ๋กœ ๋ณด๊ธฐ ์ง€์น˜์ง€ ์•Š๊ฒŒ ๋ฌด๊ฒ๊ฒŒ ๊ฐ ์žก๊ณ  ํ•˜์ง€๋ง๊ธฐ 2024. 6. 13.
728x90
๋ฐ˜์‘ํ˜•