πŸ“š Databases

MySQL μ™Έλž˜ν‚€ 적용 ν…Œμ΄λΈ” μ‚­μ œν•˜κΈ°

2022. 5. 16. 09:05
λͺ©μ°¨
  1. μ™Έλž˜ν‚€κ°€ μžˆλŠ” ν…Œμ΄λΈ”μ„ μ‚­μ œν•˜λ €ν–ˆλ”λ‹ˆ μ•„λž˜μ²˜λŸΌ μ—λŸ¬κ°€ λ°œμƒ
  2. μ™Έλž˜ν‚€ ν•΄μ œ ν›„ ν…Œμ΄λΈ”μ„ μ‚­μ œν•˜μ‹œλ©΄ λ©λ‹ˆλ‹€.
  3. REFERENCE
λ°˜μ‘ν˜•

 

μ™Έλž˜ν‚€κ°€ μžˆλŠ” ν…Œμ΄λΈ”μ„ μ‚­μ œν•˜λ €ν–ˆλ”λ‹ˆ μ•„λž˜μ²˜λŸΌ μ—λŸ¬κ°€ λ°œμƒ

mysql> drop table ν…Œμ΄λΈ”_λͺ…;
ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails

μ™Έλž˜ν‚€ ν•΄μ œ ν›„ ν…Œμ΄λΈ”μ„ μ‚­μ œν•˜μ‹œλ©΄ λ©λ‹ˆλ‹€.

mysql> SET foreign_key_checks = 0;
Query OK, 0 rows affected (0.00 sec)

mysql> drop table ν…Œμ΄λΈ”_λͺ…;
Query OK, 0 rows affected (0.00 sec)

mysql> SET foreign_key_checks = 1;
Query OK, 0 rows affected (0.00 sec)

REFERENCE

  • https://zetawiki.com/wiki/MySQL_μ™Έλž˜ν‚€_적용_ν…Œμ΄λΈ”_μ‚­μ œ
λ°˜μ‘ν˜•
μ €μž‘μžν‘œμ‹œ (μƒˆμ°½μ—΄λ¦Ό)
  1. μ™Έλž˜ν‚€κ°€ μžˆλŠ” ν…Œμ΄λΈ”μ„ μ‚­μ œν•˜λ €ν–ˆλ”λ‹ˆ μ•„λž˜μ²˜λŸΌ μ—λŸ¬κ°€ λ°œμƒ
  2. μ™Έλž˜ν‚€ ν•΄μ œ ν›„ ν…Œμ΄λΈ”μ„ μ‚­μ œν•˜μ‹œλ©΄ λ©λ‹ˆλ‹€.
  3. REFERENCE
'πŸ“š Databases' μΉ΄ν…Œκ³ λ¦¬μ˜ λ‹€λ₯Έ κΈ€
  • μ‹œκ³„μ—΄ 데이터λ₯Ό μ²˜λ¦¬ν•˜λŠ” InfluxDB에 λŒ€ν•΄μ„œ μ•Œμ•„λ³΄μž
  • [influxDB] 데이터 이관 μž‘μ—…(+ 데이터 μ €μž₯ 경둜 λ³€κ²½)
  • [influxDB] μ„€μΉ˜ν•˜κΈ° (with. Docker)
iseunghan
iseunghan
κΎΈμ€€ν•˜κ²Œ μ—΄μ‹¬νžˆ..
iseunghanκΎΈμ€€ν•˜κ²Œ μ—΄μ‹¬νžˆ..
iseunghan
iseunghan

곡지사항

  • μ–΄μ œλ³΄λ‹€ λ‚˜μ€ 였늘이 되기 μœ„ν•΄ πŸ”₯
  • λΆ„λ₯˜ 전체보기 (260)
    • πŸ’ Spring (14)
      • κ°œλ… 및 이해 (2)
      • Spring 핡심 기술 (24)
      • Spring REST API (8)
      • Spring MVC, DB μ ‘κ·Ό 기술 (7)
      • Spring Security (23)
      • Spring in Action (1)
    • 🌻 JAVA (84)
      • μžλ°” ORM ν‘œμ€€ JPA ν”„λ‘œκ·Έλž˜λ° (20)
      • μ•Œκ³ λ¦¬μ¦˜, 자료ꡬ쑰 (13)
      • λ””μžμΈ νŒ¨ν„΄ (7)
      • 정리정리정리 (43)
      • JUnit (1)
    • πŸ”– Snippets (3)
      • Javascript (3)
    • βš™οΈ Devops (22)
      • ⛏ Git (11)
      • 🐳 Docker (6)
      • 🐧 Linux (3)
      • 🌈 Jenkins (1)
      • πŸ“¬ Kafka (1)
    • πŸ’¬ ETC.. (4)
      • πŸ’» macOS (2)
    • 🌧️ ORM (2)
      • JPA (2)
    • 🐍 Python (1)
    • πŸ“š Databases (15)
      • 였라클둜 λ°°μš°λŠ” λ°μ΄ν„°λ² μ΄μŠ€ 개둠과 μ‹€μŠ΅(2판) (3)
      • RealMySQL 8.0 (8)
    • πŸ”₯ Computer Science (5)
      • πŸ“‘ λ„€νŠΈμ›Œν¬ (5)
    • 🏷️ ν˜‘μ—… (1)
    • πŸ“œ μ½”λ”©ν…ŒμŠ€νŠΈ (38)
      • BAEKJOON\μˆ˜ν•™ 1, μˆ˜ν•™ 2 (8)
      • BAEKJOON\μž¬κ·€ (5)
      • BAEKJOON\브루트 포슀 (3)
      • BAEKJOON\μ •λ ¬ (1)
      • BAEKJOON\λ°±νŠΈλž˜ν‚Ή (5)
      • BAEKJOON\BFS, DFS (6)
      • BAEKJOON\이뢄탐색 (1)
      • BAEKJOON\λ‹€μ΄λ‚˜λ―Ή ν”„λ‘œκ·Έλž˜λ° (9)
      • BAEKJOON\그리디 μ•Œκ³ λ¦¬μ¦˜ (0)
    • ✨ ISEUNGHAN (1)

인기 κΈ€

졜근 κΈ€

전체
였늘
μ–΄μ œ
λ°˜μ‘ν˜•
hELLO Β· Designed By μ •μƒμš°.
iseunghan
MySQL μ™Έλž˜ν‚€ 적용 ν…Œμ΄λΈ” μ‚­μ œν•˜κΈ°
μƒλ‹¨μœΌλ‘œ

ν‹°μŠ€ν† λ¦¬νˆ΄λ°”

κ°œμΈμ •λ³΄

  • ν‹°μŠ€ν† λ¦¬ ν™ˆ
  • 포럼
  • 둜그인

단좕킀

λ‚΄ λΈ”λ‘œκ·Έ

λ‚΄ λΈ”λ‘œκ·Έ - κ΄€λ¦¬μž ν™ˆ μ „ν™˜
Q
Q
μƒˆ κΈ€ μ“°κΈ°
W
W

λΈ”λ‘œκ·Έ κ²Œμ‹œκΈ€

κΈ€ μˆ˜μ • (κΆŒν•œ μžˆλŠ” 경우)
E
E
λŒ“κΈ€ μ˜μ—­μœΌλ‘œ 이동
C
C

λͺ¨λ“  μ˜μ—­

이 νŽ˜μ΄μ§€μ˜ URL 볡사
S
S
맨 μœ„λ‘œ 이동
T
T
ν‹°μŠ€ν† λ¦¬ ν™ˆ 이동
H
H
단좕킀 μ•ˆλ‚΄
Shift + /
⇧ + /

* λ‹¨μΆ•ν‚€λŠ” ν•œκΈ€/영문 λŒ€μ†Œλ¬Έμžλ‘œ 이용 κ°€λŠ₯ν•˜λ©°, ν‹°μŠ€ν† λ¦¬ κΈ°λ³Έ λ„λ©”μΈμ—μ„œλ§Œ λ™μž‘ν•©λ‹ˆλ‹€.