SQL Trigger

[#1]

Hello,
I'm having trouble creating an SQL Trigger statement. Does Plus net support Triggers?
The code I am attempting to use is:
CREATE TRIGGER first-trigger AFTER INSERT
and it always results with the following error:
ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER first_trigger AFTER INSERT' at
Has anyone else experienced, or know the solution, to such a problem?
Any help would be most appreciated.
Thanks in advance,
Logical

[#2]

Triggers are only available in MySQL 5+
Humbug and Rumpus both have 4.1 (I believe!)
Barry

[#3]

Yep, that is correct.
PN are planning to upgrade the MySQL servers in the not to distant future to the latest MySQL 5 version.

[#4]

Quote from: Peter

Yep, that is correct. PN are planning to upgrade the MySQL servers in the not to distant future to the latest MySQL 5 version.

That's disapointing. When is this expected to be implemented by?

[#5]

Unfortunately we don't have a set time for this yet, the project hasn't kicked off. We should have more information in the coming weeks.