codestates / codestates/ThereWeather

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

Open
#167 0 comments 0 reactions 0 assignees View on GitHub
error
Dominant language
JavaScript
Stars
0
Forks
3
PR merge metrics
No merged PRs in 30d

Description

## ์–ด๋–ค ์—๋Ÿฌ์ธ๊ฐ€์š”?
- ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์—์„œ 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)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.