Create Tigger in memsql not allowing

Help Procedural SQL
1

my memsql version 5.1
and trying to create the trigger it is not allowing is there any option ?

DELIMITER $$
CREATE TRIGGER Update_Information BEFORE UPDATE
ON employee FOR EACH ROW
BEGIN
:new.updated_date = CURRENT_DATE()
END $$
DELIMITER ;

SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER Update_Information BEFORE UPDATE

what is issue here can some comment on this… Thanks in Advance

1 Like
2

Hi @sumanamara2020 – we don’t currently support triggers. We are considering triggers for a future release. For now, if you need triggering logic, you’ll need to do it in the application.

Feel free to create a feature request (in that section of the forums) and then other people an vote for it if they like it!

1 Like
3

any alternate way to create an trigger

4

What do you want to use a trigger for?