MySQL Forums
Forum List  »  Triggers

Re: Table access from triggers has been enabled in 5.0-bk
Posted by: Jonathan Stephens
Date: August 01, 2005 07:57AM

Explicit table references are available in triggers beginning with the MySQL 5.0.10-beta release. The documentation for CREATE TRIGGER has been updated and includes an example. This will be available in the online Manual soon.

BTW, your TYPE clause is incorrect, since it omits the = sign. In any case, you should now use ENGINE=INNODB, as TYPE is now deprecated. (Note that you don't have to use InnoDB in order to enable triggers - MyISAM tables support triggers just fine.)

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation

Edited 1 time(s). Last edit at 08/01/2005 08:08AM by Jon Stephens.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.