I have been experimenting with different methods to create a table that includes a foreign key and then insert it into phpMyAdmin. Unfortunately, the results are not meeting my expectations.
Here is what I have tried:
CREATE TABLE user (
user_id BIGINT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
user_name VARCHAR(50) NOT NULL,
user_password VARCHAR(50) NOT NULL);
The above code works perfectly fine. However, when I attempt to add a table with a foreign key like this, it does not allow me to create it:
CREATE TABLE article (
article_id INT(20) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
article_title VARCHAR(100) NOT NULL,
article_content VARCHAR(1000) NOT NULL,
user_id INT(10) NOT NULL,
FOREIGN KEY (user_id) REFERENCES user (user_id));
This setup fails to add the table to the MySQL database and triggers the following error message:
Cannot add foreign key constraint
How can I resolve this issue?