Index prefixes on foreign key columns are not supported.In the referenced table, there must be an index where the referenced columns are listed as the first columns in the same order.To declare foreign keys in MySQL, there are few points which user should bear in mind: If you use "On Delete Set Null" but the field doesn't allow null.If the two fields (Field name and the Foreign Field name) are using incompatible field type. These errors are related to MySQL itself. There are some possible cases that might cause failure on creating Foreign Keys on MySQL database. If you receive MySQL Error likes 1005: Can't create table '.\mydb\#sql-44c_1c.frm'(errno: 150), it is caused by failure on creating Foreign Keys. Why I cannot successfully create the foreign keys?Īpply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for SQLite, Navicat for Oracle, Navicat for MariaDB, Navicat Premium
0 Comments
Leave a Reply. |