cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Trigger

logical
Grafter
Posts: 28
Registered: 12-08-2007

SQL Trigger

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
4 REPLIES
Community Veteran
Posts: 3,789
Registered: 08-06-2007

Re: SQL Trigger

Triggers are only available in MySQL 5+
Humbug and Rumpus both have 4.1 (I believe!)
Barry
Community Veteran
Posts: 14,469
Registered: 30-07-2007

Re: SQL Trigger

Yep, that is correct.
PN are planning to upgrade the MySQL servers in the not to distant future to the latest MySQL 5 version.
logical
Grafter
Posts: 28
Registered: 12-08-2007

Re: SQL Trigger

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?
Community Gaffer
Community Gaffer
Posts: 17,665
Thanks: 658
Fixes: 162
Registered: 05-04-2007

Re: SQL Trigger

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.
If this post resolved your issue please click the 'This fixed my problem' button
 Chris Parr
 Plusnet Staff