teratail
回答率
85.35%
teratail header banner
teratail header banner
質問するログイン新規登録
トップに関する質問mysqlテーブル作成でエラーが出る

編集履歴

質問編集履歴

2

誤字

2021/12/27 09:50

投稿

kirakira3003
kirakira3003

スコア20

test CHANGED
File without changes
test CHANGED
File without changes

1

誤字

2021/12/27 09:49

投稿

kirakira3003
kirakira3003

スコア20

test CHANGED
File without changes
test CHANGED
@@ -14,7 +14,7 @@
14
14
 
15
15
  ```
16
16
 
17
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PEFERENCES kokyaku_tbl(kok_id), FOREIGN KEY(horse_id) PEFERENCES horse_tbl(horse' at line 1
17
+ ERROR 1005 (HY000): Can't create table '.\nhs10600db\yoso_tbl.frm' (errno: 150)
18
18
 
19
19
  ```
20
20
 
@@ -34,11 +34,11 @@
34
34
 
35
35
  race_id varchar(10),
36
36
 
37
- FOREIGN KEY(kok_id) PEFERENCES kokyaku_tbl(kok_id),
37
+ FOREIGN KEY(kok_id) REFERENCES kokyaku_tbl(kok_id),
38
38
 
39
- FOREIGN KEY(horse_id) PEFERENCES horse_tbl(horse_id),
39
+ FOREIGN KEY(horse_id) REFERENCES horse_tbl(horse_id),
40
40
 
41
- FOREIGN KEY(race_id) PEFERENCES race_tbl(race_id),
41
+ FOREIGN KEY(race_id) REFERENCES race_tbl(race_id),
42
42
 
43
43
  PRIMARY KEY(yoso_id));
44
44