[Cialug] mysql triggers

[carl-olsen at mchsi.com]

I have that book.  I also use that web site frequently.

Stored procedures (and triggers) are much easier to write in MySQL, but their performance is much worse than PostgreSQL.  So, I'm not using stored procedures with MySQL.  I do use triggers once in a while.  With PostgreSQL, I used stored procedures for just about everything.

Carl Olsen
Des Moines, IA

-------------- Original message ----------------------
From: "Matthew Nuzum" <newz at bearfruit.org>
>
> Seems we were just talking about this, but couldn't find the exact
> thread at a casual glance...
> 
> Anyway, I get e-mails about new articles from devshed, and this came through:
> http://www.devshed.com/c/a/MySQL/Error-Handling/
> 
> Talks about writing MySQL procedures in the context of generating
> useful exceptions. Its from a book on the subject of mysql stored
> procedures. It looks interesting. Unfortunately, its part one of
> three...
> 
> I like the CALL syntax better than PostgreSQL's SELECT syntax.
> (Although PG's set returning functions make perfect sense with the
> SELECT syntax)
> 
> -- 
> Matthew Nuzum
> newz2000 on freenode
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug