Database Table A: CREATE TABLE task_desc_tab ( id INT(11) PRIMARY KEY NOT NULL COMMENT 'Auto-increment primary key' AUTO_INCREMENT, <strong>taskname</strong> VARCHAR(200) NOT NULL COMMENT 'Task name', sqlname VARCHAR(20) NOT NULL COMMENT 'sql file name', params VARCHAR(5000) NOT NULL COMMENT 'Task parameters, in the format of a JSON string', updatetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT 'Update time', detail VARCHAR(3000) COMMENT 'Some description information of the task, just for notes' ) ENGINE = InnoDB DEFAULT CHARSET = utf8; Database B: CREATE TABLE exec_plan_tab ( id INT(11) PRIMARY KEY NOT NULL AUTO_INCREMENT, <strong>taskname</strong> VARCHAR(200) NOT NULL, startdate DATE NOT NULL, enddate DATE NOT NULL, updatetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, CONSTRAINT exec_plan_tab_task_desc_tab_taskname_fk FOREIGN KEY (taskname) REFERENCES task_desc_tab (taskname) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; Goal: Create a table so that taskname in table B is a foreign key. Refer to the taskname field in table A. When creating the table, the following error is reported:
After troubleshooting, we found the cause of the problem: taskname in table A must be modified with the UNIQUE field to ensure the uniqueness of the record and avoid ambiguity when referenced by table B. The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM. You may also be interested in:
|
<<: js to achieve sliding carousel effect
>>: Use of Linux crontab command
As we all know, the web pages, websites or web pag...
Introduction Today I will share the use of the su...
Firefox, Opera and other browsers do not support W...
<br />Based on the original width-and-height...
The Docker images we usually build are usually la...
The optimization created by MySQL is to add index...
Table of contents docker system df docker system ...
Includes the process of initializing the root use...
MySQL replace and replace into are both frequentl...
The following information is compiled from the Int...
This article uses an example to illustrate the us...
need Recently, we need to migrate Node online ser...
Jenkins is an open source software project. It is...
Table of contents Portainer manages multiple Dock...
First, let me show you the finished effect Main i...