Shulou(Shulou.com)06/01 Report--

This article will explain in detail the solutions that cannot be saved by setting foreign keys in navicat. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

1. Note that when designing tables, the engine in the option should be selected as InnoDB, because InnoDB provides transaction support and advanced database functions such as external keys.

2. Then create a foreign key in a table, select the "foreign key" tab, enter the name of referential integrity, select which attribute is the foreign key, select the primary key in which table as the foreign key, and so on. Then click Save. Note that if there is a problem at this time, you can check whether the primary key foreign key is of the same type, and if the primary key foreign key is numeric, check the unsigned check box in the design table.

This is the end of the article on "the solution that cannot be saved by setting foreign keys in navicat". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.