How to create foreign key in MySQL?


A foreign key in MySQL is basically a column or group of columns in a table that does the work of linking to a column or group of columns in another table. This key generally places constraints on the data in the related table that usually allows MySQL to maintain referential integrity.

The relationship that exists between the customer's table and the Orders table is basically one-to-many. And this is the relationship that has been established by the foreign key in the orders table that has been specified by the customer number column.

The customer's table is also known as the parent table or referenced table, and the orders table is generally called as the child table or referencing table.

How to create Foreign Key?

In order to create this, the user has to use the basic syntax of defining a foreign key constraint in the CREATE TABLE or ALTER TABLE statement that is as depicted below:

[CONSTRAINT constraint_name]

FOREIGN KEY [foreign_key_name] (column_name, ...)

REFERENCES parent_table(colunm_name,...)

[ON DELETE reference_option]

[ON UPDATE reference_option]

In this above-mentioned syntax, the user has to first specify the name of the constraint that they want to create after the CONSTRAINT keyword. In case, the user omits the constraint name then the MySQL will automatically generate a name for the constraint.

Secondly, the user has to specify a list of comma-separated columns after the keywords. The name is generally optional and it is generated automatically in case the user skips it. In the third step, the user has to specify the parent table that is followed by a list of comma-separated columns to which the columns reference.

This is a very important topic in the whole of a subject and there are various things that can be learned to master it hence, the students or the programmers can opt for the MySQL Tutorial that will clear all the steps and the topics that are involved in this subject. Like the final step of how to create a foreign key. 

Lastly and the final step involves specifying how this factor maintains the referential integrity that is between the child and parent tables with the help of ON DELETE and ON UPDATE clauses.

Read More...
Also, Visit Here  MySQL Tutorial for Beginners

Comments

Post a Comment

Popular posts from this blog

Laravel Tutorial for Beginners

Image
Laravel Tutorial  Laravel Tutorial for Beginners Laravel is known as an elegant, expressive and flexible PHP framework that has the extreme focus on clean code and speed that basically describes itself as “The PHP framework for web artisans”. This is an Open source PHP framework that has been created by Taylor Otwell, and it is based on Model View Controller (MVC) architecture. If you are a beginner then creating a web application from the scratch can be daunting sometimes hence, it is recommended that you should learn it from the finest Laravel Tutorial for Beginners . A simple web application generally consists of various small and big pieces and while creating those pieces every time the programmer is creating a web app that can be boring and repetitive and it can be said that there is no point in reinventing wheels. This PHP framework comes into the picture at this time. Laravel framework is known to deliver various PHP libraries and the helper functions that ...
Read more

Ajax Tutorial

Image
Ajax Tutorial for Beginners In order to learn the concept grasping knowledge that is needed for this very topic is available on all of the AJAX Tutorial that is generally available on the web and that too in abundance. This is generally an abbreviation that basically elaborates to Asynchronous JavaScript and XML.  In the abbreviation, XML is rarely meant to be of any use but in terms of developing the web applications, it is basically used to perform the asynchronous things that are like updating a page, making actions, etc.  This is all about updating the sections of a webpage in a way that the need for reloading the pages gets eliminated. This is the very technology that basically relies on a bunch of technologies. The user or the programmer doesn’t have to an expert in all of these technologies just a little background knowledge will do the job. Ajax’s Anatomy? There are numerous technologies that are generally involved in this very technical an...
Read more

CodeIgniter Tutorial

Image
Build a web-based application with the help of Codeigniter If you are looking for a way to build an application in a fast and reliable way, then this is how you can do so. When people have developed a lot, and most of the things have shifted from offline to the online world, it has become necessary for many programmers to learn languages that can help them secure and build their careers.  Codeigniter is one such web application framework toolkit that has been designed in such a manner that it becomes one of the best friends of every web developer. One will find that it is one of the easiest ways to build an application and even use it with the help of an online Codeigniter tutorial. With the help of these tutorials, you can easily learn to use it from your home itself and start building your own web-based applications. Why is Codeigniter important? Fastest framework : When you look forward to competing Codeigniter to any other toolkit, it is considered to be having the fastest and ...
Read more