how to create foreign key in mysql

we can define foreign key in MYisam engine just use following ex.

Create Table subcat(SId int(2) Primary Key Not Null Auto_Increment,Name varchar(10),cid int(2),foreign key (SId) references category(id))

Advertisement