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))

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!

Follow

Get every new post delivered to your Inbox.