Arsalan Nezhadfard
Last answered:

23 Nov 2022

 Posted on:

22 Nov 2022
0

error on adding foriegn key

in SQL / FOREIGN KEY constraint - Part II

I have a problem trying this manually

image.png

1 answers ( 0 marked as helpful)
Tsvetelin Tsonkov
Instructor
Posted on:

23 Nov 2022
0

Hi Arsalan!
Thanks for reaching out.

It seems that this name is already used. Please, use another name for this constraint.

Hope this helps.
Best,
Tsvetelin

Submit an answer

related questions

Jaycus Goh
1
38
foreign key tab missing foreign key
THOMAS BELL
0
16
14. SQL JOINs - Error Code: 1055 (only_full_group_by)
Marcus Wern Han Leong
2
16
Why did you not do not null, primary key and auto increment for customer id in the solution?
Harsha Dharmabandu
1
14
Resolved: foreign key : able to see foreign key in the table sales DDL tab , but the Foreign Keys tab is empty
yenni kosasih
0
14
error code 1140 : in aggregated query without group by
Michele Cannito Buch
0
12
Resolved: DROP FOREIGN KEY sales_ibfk_1 -- huh?
Christopher Watts
1
12
Error Code: 1364. Field 'customer_id' doesn't have a default value
Joe
1
10
Resolved: S Error code 1055