Join the social network of Tech Nerds, increase skill rank, get work, manage projects...

What is FOREIGN KEY Constraint in MySQL?

Note that the "P_Id" column in the "Orders" table points to the "P_Id" column in the "Persons" table. In MySQL, the FOREIGN KEY on one table is used to point a PRIMARY KEY in another table. We have two tables with the following values. ...

How to add foreign key contraint to a column in MySql?

In many cases we need to create foreign key in a table. We can do this at the time of table creation and after the table creation by ALTER command. 1- At the time of table creation: CREATE TABLE user_device ( id int(11) NOT NULL AUTO...
Sign In

Sign up using

Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: