MySQL Foreign Key Format

Any time

Open links in new tab

✕
This summary was generated using AI based on multiple online sources. To view the original source information, use the "Learn more" links.
MySQL Foreign Key Example
¹²³
laravel - General error: 1824 Failed to open the referenced table - St…
https://stackoverflow.com/questions/60826299/general-error-1824-failed-to-open-the-referenced-table
MySQL :: MySQL 8.4 Reference Manual :: 15.1.20.5 FOREIGN KEY C…
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
MySQL FOREIGN KEY Constraint
https://www.w3schools.com/mysql/mysql_foreignkey.asp
A foreign key in MySQL establishes a relationship between two tables, ensuring referential integrity. It links a column in the child table to the primary key in the parent table.
Example: Creating a Foreign Key
CREATE TABLE categories (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL
);

CREATE TABLE products (
id INT AUTO_INCREMENT PRIMARY KEY,
category_id INT,
name VARCHAR(255) NOT NULL,
FOREIGN KEY (category_id) REFERENCES categories(id)
);
✕
Copy
Copied!
In this example:
The categories table is the parent table with id as its primary key.
The products table is the child table, where category_id is a foreign key referencing categories(id).
Adding a Foreign Key to an Existing Table
If the child table already exists, you can add a foreign key using ALTER TABLE:
ALTER TABLE products
ADD CONSTRAINT fk_category
FOREIGN KEY (category_id) REFERENCES categories(id);
✕
Copy
Copied!
Important Considerations
Both tables must use the same storage engine (e.g., InnoDB).
The data types of the foreign key and referenced column must match.
Ensure the parent table exists before creating the foreign key.
Use ON DELETE CASCADE or ON DELETE SET NULL for cascading delete behavior if needed.
See more
See less
Examples from GitHub
PatilShreyas/MyCart-CLI • mykart.sql
DROP TABLE IF EXISTS `coupons_used`;

CREATE ALGORITHM = UNDEFINED DEFINER =`` SQL SECURITY DEFINER VIEW `coupons_used` AS
select `i`.`APPLIED_COUPON` AS `APPLIED_COUPON`,
`i`.`ORDER_ID` AS `ORDER_ID`,
`o`.`TIMESTAMP` AS `TIMESTAMP`,
`o`.`USER_ID` AS `USER_ID`
PatilShreyas/MyCart-CLI • mykart.sql
ADD PRIMARY KEY (`ORDER_ID`),
ADD KEY `orders_ibfk_1` (`USER_ID`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
GitHub
51
MySQL Foreign Key
This tutorial introduces you to MySQL foreign key constraints and shows you how to manage foreign keys effectively.
MySQL Tutorial
Watch video
34:45
Foreign Key in MySQL A to Z: Complete Guide for Beginners
YouTube19 views
Does MySQL support foreign key references?
MySQL supports foreign key references between one column and another within a table. (A column cannot have a foreign key reference to itself.) In these cases, a “child table record” refers to a dependent record within the same table.
dev.mysql.com
Foreign key best practices
MySQL foreign key examples
Foreign key syntax examples

MySQL
https://dev.mysql.com › doc › refman › en › create-table-foreign-keys.html
15.1.20.5 FOREIGN KEY Constraints - MySQL
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent.
W3School
https://www.w3schools.com › mysql › mysql_foreignkey.asp
MySQL FOREIGN KEY Constraint - W3Schools
The FOREIGN KEY constraint is used to prevent actions that would destroy links between tables. A FOREIGN KEY is a field (or collection of fields) in one table, that refers to the PRIMARY KEY in …
Code sample
OrderNumber int NOT NULL,
PersonID int,
PRIMARY KEY (OrderID),
CONSTRAINT FK_PersonOrder FOREIGN KEY (PersonID)
REFERENCES Persons(PersonID)...
See more on w3schools
Feedback
Thanks!Tell us more
GeeksForGeeks
https://www.geeksforgeeks.org › mysql › mysql-foreign-key-constraint
MySQL FOREIGN KEY Constraint - GeeksforGeeks
Jul 23, 2025 · In this article, we will learn about how to use foreign keys in MySQL with examples. The FOREIGN KEY creates a relationship between the columns in the current table or let's say …
MySQL Tutorial
https://www.mysqltutorial.org › ... › mysql-foreign-key
MySQL Foreign Key
This tutorial introduces you to MySQL foreign key constraints and shows you how to manage foreign keys effectively.
Codegenes
https://www.codegenes.net › blog › view-all-foreign...
How to View All Foreign Key Constraints for an Entire MySQL …
5 days ago · Foreign key (FK) constraints are the backbone of relational databases, ensuring data integrity by enforcing relationships between tables. They define how columns in one table (the …
dolthub.com
https://www.dolthub.com › blog
MySQL Foreign Keys: How and why with examples | DoltHub Blog
Mar 5, 2025 · In this tutorial, learn how to use foreign keys in MySQL and what they're good for, with examples
People also ask
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column values, and a child table with column values that reference the parent column values.
Continue Reading
15.1.20.5 FOREIGN KEY Constraints - MySQL
dev.mysql.com·https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
A FOREIGN KEY is a field (or collection of fields) in one table, that refers to the PRIMARY KEY in another table. The table with the foreign key is called the child table, and the table with the primary key is called the referenced or parent table. Look at the following two tables:
Continue Reading
MySQL FOREIGN KEY Constraint - W3Schools
w3schools.com·https://www.w3schools.com/mysql/mysql_foreignkey.asp
The easiest way to examine the foreign keys on a table is with the SHOW CREATE TABLE statement just like we did above. The output includes the entire statement required to recreate the schema of the table, including all constraints, indexes, and other properties of the table. If you no longer want a foreign key constraint, you can drop it.
Continue Reading
MySQL Foreign Keys: How and why with examples | DoltHub Blog
dolthub.com·https://www.dolthub.com/blog/2025-03-05-mysql-foreign-keys/
Feedback
Stack Overflow
https://stackoverflow.com › questions
What is a proper naming convention for MySQL FKs?
Feb 10, 2010 · Oracle & SQL Server allow you to disable specific constraints. If you don't have fk in the name, you have to confirm the constraint is a …
Sling Academy
https://www.slingacademy.com › article
Working with FOREIGN KEY in MySQL 8: A Developer’s Guide
Jan 27, 2024 · In this developer’s guide, we will delve into the use of FOREIGN KEY constraints in MySQL 8, covering everything from the basics to more advanced topics with practical examples …
DEV Community
https://dev.to
Mastering Foreign Keys in MySQL: A …
Jun 4, 2025 · In MySQL, most of us are familiar with primary keys and their main role in uniquely identifying rows within a table. However, foreign keys …
SQL Shack
https://www.sqlshack.com › a-quick-overview-of-mys…
A quick overview of MySQL foreign key with …
In this article, we will learn how to work with MySQL foreign keys with a few examples. A typical data modeling process starts with conceptual data …

People also search for
Deep dive into MySQL Foreign Key Format
Pagination
- 1
- 2
- 3
- Next

MySQL Foreign Key Example

laravel - General error: 1824 Failed to open the referenced table - St…

https://stackoverflow.com/questions/60826299/general-error-1824-failed-to-open-the-referenced-table

MySQL :: MySQL 8.4 Reference Manual :: 15.1.20.5 FOREIGN KEY C…

https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html

MySQL FOREIGN KEY Constraint

https://www.w3schools.com/mysql/mysql_foreignkey.asp

Examples from GitHub

15.1.20.5 FOREIGN KEY Constraints - MySQL

MySQL FOREIGN KEY Constraint - W3Schools

Code sample

MySQL FOREIGN KEY Constraint - GeeksforGeeks

MySQL Foreign Key

How to View All Foreign Key Constraints for an Entire MySQL …

MySQL Foreign Keys: How and why with examples | DoltHub Blog

What is a proper naming convention for MySQL FKs?

Working with FOREIGN KEY in MySQL 8: A Developer’s Guide

Mastering Foreign Keys in MySQL: A …

A quick overview of MySQL foreign key with …

Deep dive into MySQL Foreign Key Format

Deep dive into MySQL Foreign Key Format

laravel - General error: 1824 Failed to open the referenced table - St…

https://stackoverflow.com/questions/60826299/general-error-1824-failed-to-open-the-referenced-table

MySQL :: MySQL 8.4 Reference Manual :: 15.1.20.5 FOREIGN KEY C…

https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html

MySQL FOREIGN KEY Constraint

https://www.w3schools.com/mysql/mysql_foreignkey.asp

Examples from GitHub

Code sample

What is a foreign key in MySQL?

What is a foreign key in a table?

Does MySQL support foreign key references?

How to examine foreign keys on a table?

Deep dive into MySQL Foreign Key Format