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
Docker officially recommends that we use port map...
This article shares the specific code for JavaScr...
Enter Alibaba vector icon library Alibaba Vector ...
1. Introduction The topic of whether to use forei...
1. Open port 2375 Edit docker.service vim /lib/sy...
background Now the company's projects are dev...
The use of vue3 Teleport instant movement functio...
In MySQL database operations, we always hope to a...
Running Docker requires root privileges. To solve...
Many people have read this book: "Grow as a ...
Table of contents Single Node Diff reconcileSingl...
Table of contents 1. Theory SERIALIZABLE REPEATAB...
1. What affects database query speed? 1.1 Four fa...
The previous article on Docker mentioned the cons...
I like to pay attention to some news on weekdays a...