Re: TRIGGER BEFORE INSERT - ALTER ADD column form insert value

[William Chiquito]

Hi Mihai,

See:

Quote

F.1. Restrictions on Stored Routines and Triggers
...
For stored functions (but not stored procedures), the following additional statements or operations are disallowed:
* Statements that do explicit or implicit commit or rollback.
...

Quote

12.4.3. Statements That Cause an Implicit Commit
Each of the following statements (and any synonyms for them) implicitly end a transaction, as if you had done a COMMIT before executing the statement:
* ALTER TABLE, BEGIN, CREATE INDEX, DROP INDEX, DROP TABLE, LOAD MASTER DATA, LOCK TABLES, LOAD DATA INFILE, RENAME TABLE, SET AUTOCOMMIT=1 (if the value is not already 1), START TRANSACTION, UNLOCK TABLES.
...

Edited 3 time(s). Last edit at 05/28/2008 04:36PM by William Chiquito.