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. 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. Link to comment https://forums.phpfreaks.com/topic/85013-foreign-key-issue/#findComment-433610 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.