PDOStatement: SUPER privilege?

by jernst, Thursday, August 07, 2014, 19:54 (3604 days ago) @ jernst
edited by jernst, Thursday, August 07, 2014, 20:24

I guess I'm having a conversation with myself here...

Update: This post is wrong. If executed from the command-line, I need to change the delimiter first, so the command-line parser does not barf on the ; contained in the trigger. That is not necessary when executed through PHP. So this particular error is not relevant to my original problem.

About that trigger:

CREATE TRIGGER insert_updatetime_trigger
BEFORE INSERT ON items FOR EACH ROW
BEGIN
SET NEW.updatetime = NOW();
END

Just found out that attempting to create that trigger manually produces a:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 4 (very helpful, I should say)

Database is: mysql Ver 15.1 Distrib 10.0.12-MariaDB

Anybody know more about triggers than I do with an idea what the problem might be here?


Complete thread:

 RSS Feed of thread

powered by my little forum