- You can define triggers (MySQL can't do this).
From: http://www.mysql.com/products/mysql/
"Stored procedures and triggers
Stored procedures allow you to create functions and subroutines that run on the server. This makes it possible to grant access to specific queries without granting carte blanche access to the underlying data, or validate data in the database before it is stored. Triggers can be configured to fire when certain conditions are fulfilled.
The MySQL database server will provide hooks for implementing stored procedures in multiple languages, as well as including support for the Persistent Stored Modules syntax defined as part of ANSI SQL-99.
Support for stored procedures was added in version 5.0, and support for triggers will be added in version 5.1."
Plus they have some documentation for it already.
http://www.mysql.com/documentation/maxdb/a7/41ee0b605911d3a98800a0c9449261/content.htm
A friend of mine that uses MySQL says that it's in the dev version already.
_______________________________________________ gnhlug-discuss mailing list [EMAIL PROTECTED] http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss
