Re: Fixing: "Trigger in wrong schema. Error 1435"

[Dmitri Lenev]

Hi, Rick!

MySQL emits "Trigger in wrong schema" (error number 1435) error when one tries to create trigger in database which is different from database where its subject table resides.

In your particular case:

CREATE TRIGGER trg_DATATABLE
BEFORE INSERT ON test.DATATABLE
FOR EACH ROW ...

Means that you are trying to create trigger in _current_ database probably differs from 'test'.

So you should solve your problems by simply doing:

CREATE TRIGGER test.trg_DATATABLE
BEFORE INSERT ON test.DATATABLE
FOR EACH ROW ...

Best regards,
--
Dmitri Lenev, Software Developer
MySQL AB, www.mysql.com

Are you MySQL certified? http://www.mysql.com/certification