mysql 在插入时创建触发器

Question

假设我有下表

create table try  ( name varchar(10), username varchar(10))

是否可以使用“ON INSERT”触发器来设置 username=user() ？

我试过

create trigger userIns ON INSERT on try for each row set new.username=user();

但是这给出了一些语法错误

我看过有关 BEFORE INSERT、AFTER INSERT 的文档。 ON INSERT 怎么样？

如果没有，我最好的选择是什么？

Answer 1

语法是:

CREATE TRIGGER trigger_name trigger_time trigger_event
ON table_name
FOR EACH ROW
BEGIN
...
END

trigger_time 部分的语法错误。

Trigger activation time can be BEFORE or AFTER. You must specify the activation time when you define a trigger. You use BEFORE keyword if you want to process action prior to the change is made on the table and AFTER if you need to process action after change are made.

试试这个:

create trigger userIns BEFORE INSERT on try for each row set new.username=user();

更多:MYSQL Trigger Tutorial