Skip to content

Mysql and real trigger support

I just answered a question in the usenet about triggers in Mysql and discovered something very scary:

You can have only one trigger action time and event at a time for a table. So for example you can only have one "BEFORE INSERT" trigger.


I only can repeat my earlier question: how can anyone get real work done with this *censored*?

Trackbacks

ads' corner on : Safety of your data

Show preview
Just got this today after a mysqlcheck:warning : Found row where the auto_increment column has the value 0How pity, your data integrity is gone and you don't know, at which position this row was originally. Beside this, the id auto_increment column is Comments ()

Comments

Display comments as Linear | Threaded

No comments

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.
Form options