FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Is MySQL supporting Triggers?





shenyl
I am trying to consider porting a MS SQL database over to MySQL, the stored procedures looks fairly compatible, and as I search for the trigger functions in Tables, I was unable to find any.

I cannot remember where I saw it, but do remember that MySQL is finally supporting Stored Procedures and Triggers.

I am using MySQL 5.0.45 version.

Anyone can give some suggections. Thanks.
JayBee
try google or any other good source http://www.google.com/search?q=mysql+trigger

http://dev.mysql.com/doc/refman/5.0/en/triggers.html
shenyl
Thanks for the hypertext link to MySQL.

Yes, it is supported, and the Using Triggers help to clarify the topic on Triggers.

It seem to have some advantages over MS SQL, and also seem to have a few disadvantages.

Firstly, the triggers are stored separated from the table, or rather managed seperately.

Triggers can only be activated by SQL, not API - do not know the extend of this limitation.

Triggers cannot use CALL to invoke Stored procedures - a sizeable disadvantage.

Will have to try and convert the database carefully.

Thanks, it sure clarify my need for my DB conversion.
dude_xyx
I think you have to use MYSQL 5.x to use triggers.
shenyl
Hello dude_xyx, care to elaborate if version 5.0.45 is considered version 5.x?

I have not reached the conversion of the triggers yet, as I am presently stuck with building the Web Services and Web applications for my teaching subjects.

Will be helpful if you can clarify. Thanks.
bscomp
Yes? its posible? but howe its do.....
Related topics
Free Hosting-Availability
mysql connection question
php admin and mysql admin console
Mysql And PHP HELP PLZ
Do you use a CMS script?
Question about MySQL!
PHP, MySQL...
Multiple versions of PHP/MySQL
MySQL SUBselect queries and Nested queries
Which Feature u most like in Frihost??
mySQL Audit Trail option?
NEED HELP IN VIEWS AND TRIGGERS
mail system......an mysql....
Cannot Create Triggers in MySQL at Frihost
Reply to topic    Frihost Forum Index -> Computers -> Software

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.