gerkintrigg Posted January 8, 2008 Share Posted January 8, 2008 I'm trying to set a foreign key constraint using the following code: `Van_No` CHAR( 3 ) NOT NULL, Index (Van_No), Constraint FK_Van_No FOREIGN KEY (Van_No) REFERENCES Van ( Van_No ) ON DELETE CASCADE, Can you see why I'm getting a mysql error: #1005 - Can't create table './da807682/Corporate_Booking.frm' (errno: 121) ??? Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/85013-foreign-key-issue/ Share on other sites More sharing options...
fenway Posted January 8, 2008 Share Posted January 8, 2008 Sometimes that becuase the column type doesn't match. Quote Link to comment https://forums.phpfreaks.com/topic/85013-foreign-key-issue/#findComment-433610 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.