Mysql Help

[Desi-Tek.com]

How to use foreign key and store procedure in mysql? pls post the information with example.

Regards,
Dheeraj

 

[GNUrag]

How to use foreign key and store procedure in mysql? pls post the information with example.

Regards,
Dheeraj

First make sure that you are using MySQL 5.x series which now has support for Stored Procedures, Views and Triggers. For foreign keys make sure that your tables are using InnoDB engine.

it wont be wise of us to create examples for you and post here. Please do your homework first, let us know where you are stuck, and then ask.

 

[Desi-Tek.com]

actually i know how to create view, sp, trigger in ms sql, is it same in mysql? or does it has any syntax difference?

 

[GNUrag]

cool, if you already know SQL, then just head over to official MySQL documentation.

read this and try to make sense of it.
*dev.mysql.com/doc/refman/5.1/en/example-foreign-keys.html
*dev.mysql.com/doc/refman/5.1/en/views.html
*dev.mysql.com/doc/refman/5.1/en/stored-procedures.html
*dev.mysql.com/doc/refman/5.1/en/triggers.html

there is almost no syntax differences between various databases.

 

[bukaida]

How to use foreign key and store procedure in mysql? pls post the information with example.

check this out.
*www.informit.com/articles/article.asp?p=30875&seqNum=8&rl=1