faqts : Computers : Databases : MySQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

11 of 22 people (50%) answered Yes
Recently 6 of 10 people (60%) answered Yes

Entry

Q: Can i use stored procedures, foreign keys and triggers.

Feb 24th, 2008 00:18
dman, Euan MacInnes, Mayura Tolmare, http://www.ttnr.org


No you can't, these are features that are not implemented or only 
syntax implemented in version 4.0. 
This is a good thing for the most part, especially stored procedures, 
these are the least compatible things between databases, i.e. oracle, 
mssql, interbase all handle them very differently.
triggers are (for me at least) bad for the most part too as they hide 
the logic and can be difficult to trace when they go wrong. An 
application's middle tier is better suited to this type of logic