foreign key Archives - Mukesh Chapagain Blog

Alter MySQL table to add & drop column & add Foreign Key

February 7, 2012 by Mukesh Chapagain

This article shows:- – How to add column to mysql database table after the table has already been created – How to delete column from mysql database table after the table has already been created – How to add foreign key to table column after the table has already been created Basically, all this can … Read more

MySQL Database: Foreign Key Understanding and Implementation

July 18, 2011 by Mukesh Chapagain

Some definitions of foreign key:- A FOREIGN KEY in one table points to a PRIMARY KEY in another table. A foreign key is a field in a relational table that matches the primary key of another table. The foreign key can be used to cross-reference tables. A table may have multiple foreign keys, and each … Read more