codestates / codestates/ThereWeather

[๐Ÿ‘พ Error Handling] ERROR 1828 (HY000): Cannot drop column 'post_id': needed in a foreign key constraint 'custom_fkey_name'

ใ‚ชใƒผใƒ—ใƒณ
#167 ใ‚ณใƒกใƒณใƒˆ 0 ไปถ ใƒชใ‚ขใ‚ฏใ‚ทใƒงใƒณ 0 ไปถ ๆ‹…ๅฝ“่€… 0 ๅ GitHub ใง่ฆ‹ใ‚‹
error
ไธป่ฆ่จ€่ชž
JavaScript
ใ‚นใ‚ฟใƒผ
0
ใƒ•ใ‚ฉใƒผใ‚ฏ
3
PR ใƒžใƒผใ‚ธๆŒ‡ๆจ™
30ๆ—ฅไปฅๅ†…ใซใƒžใƒผใ‚ธใ•ใ‚ŒใŸ PR ใฏใ‚ใ‚Šใพใ›ใ‚“

่ชฌๆ˜Ž

## ์–ด๋–ค ์—๋Ÿฌ์ธ๊ฐ€์š”?
- ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์—์„œ foreign key ์ง€์ • ํ›„์— ๋‹ค์‹œ ์‚ญ์ œํ•˜๋ ค๊ณ , `alter table posts drop post_id;` ์ด ๋ช…๋ น์–ด๋ฅผ ์น˜๊ฒŒ ๋˜๋ฉด ๋ฐ”๋กœ ์นผ๋Ÿผ ์‚ญ์ œ๊ฐ€ ์•ˆ๋  ๋•Œ ๋‚˜์˜ค๋Š” ์—๋Ÿฌ๋ฉ”์„ธ์ง€

## ์—๋Ÿฌ ๋ฉ”์‹œ์ง€
```jsx
ERROR 1828 (HY000): Cannot drop column 'post_id': needed in a foreign key constraint 'custom_fkey_name'
```

## ์—๋Ÿฌ ํ•ธ๋“ค๋ง ๋ฐฉ๋ฒ•
```jsx
1. show create table posts[์กฐํšŒํ•  ํ…Œ์ด๋ธ”๋ช…];
2. alter table posts[์กฐํšŒํ•  ํ…Œ์ด๋ธ”๋ช…] drop foreign key custom_fkey_name[์‚ญ์ œํ•  foreign key ์ด๋ฆ„];
3. alter table posts[์กฐํšŒํ•  ํ…Œ์ด๋ธ”๋ช…] drop post_id[์‚ญ์ œํ•  ์นผ๋Ÿผ๋ช…];
```

## ์—๋Ÿฌ ํ•ธ๋“ค๋ง์„ ์œ„ํ•ด ์ฐธ๊ณ ํ•œ ๋ ˆํผ๋Ÿฐ์Šค ๋งํฌ
[์˜ˆ์‹œ1](https://gcpark.tistory.com/23)

ใ‚ณใƒณใƒˆใƒชใƒ“ใƒฅใƒผใ‚ทใƒงใƒณใ‚ฌใ‚คใƒ‰

ใ“ใฎใƒชใƒใ‚ธใƒˆใƒชใฎใ‚ณใƒณใƒˆใƒชใƒ“ใƒฅใƒผใ‚ทใƒงใƒณใ‚ฌใ‚คใƒ‰ใฏ็ดขๅผ•ใ•ใ‚Œใฆใ„ใพใ›ใ‚“

่ชฟๆŸปใฎๆ–นๅ‘ๆ€ง

No file or test is named. Start by locating the repository's existing error-handling or database documentation and compare its format with this MySQL ERROR 1828 example; done means the error message and the three stated SQL handling steps are recorded consistently.

็ดขๅผ•ใƒขใƒ‡ใƒซใŒ issue ใฎๆœฌๆ–‡ใ‹ใ‚‰ๆ›ธใ„ใŸใ‚‚ใฎใงใ™ใ€‚

่ฉ•ไพก

ๆŠ€่ก“ใ‚นใ‚ฟใƒƒใ‚ฏ
mysql
้ ˜ๅŸŸ
databases, documentation
issue ใฎ็จฎ้กž
ใƒ‰ใ‚ญใƒฅใƒกใƒณใƒˆ
้›ฃๆ˜“ๅบฆ
2/5
่ฆ‹็ฉใ‚‚ใ‚Šๆ™‚้–“
1ใ€œ3ๆ™‚้–“
ๆดป็™บใ•
ๅœๆปž
ๆ˜Ž็žญใ•
ใŠใŠใ‚€ใญๆ˜Ž็ขบ
ๅˆๅฟƒ่€…ใธใฎใ‚„ใ•ใ—ใ•
35/100

ๆ–ฐใ—ใ„ issue ใ‚’ใƒกใƒผใƒซใงๅ—ใ‘ๅ–ใ‚‹

ๅˆๅฟƒ่€…ๅ‘ใ‘ใฎ GitHub issue ใ‚’็Ÿญใใพใจใ‚ใŸใƒ€ใ‚คใ‚ธใ‚งใ‚นใƒˆใ€‚