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

Re: SQL Trigger

Triggers are only available in MySQL 5+
Humbug and Rumpus both have 4.1 (I believe!)
Barry
Peter_Vaughan
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?
Chris
Legend
Posts: 17,724
Thanks: 598
Fixes: 168
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.
Former Plusnet Staff member. Posts after 31st Jan 2020 are not on behalf of Plusnet.