mysql trigger before insert_在MYSQL中创建一个BEFORE INSERT TRIGGER

我需要帮助在mySQL Bench上创建一个BEFORE INSERT TRIGGER。即时通讯新的这个请。

CREATE TABLE `quincyninying`.`toytracking` (

`Toyid` INT NOT NULL,

`ToyName` VARCHAR(50) NULL,

`Toycost` DECIMAL NULL,

`ToyAction` VARCHAR(50) NULL,

`ActionDate` DATETIME NULL,

PRIMARY KEY (`Toyid`));

CREATE TABLE `quincyninying`.`toy` (

`Toyid` INT NOT NULL,

`ToyName` VARCHAR(50) NULL,

`Toycost` DECIMAL NULL,

PRIMARY KEY (`Toyid`));在玩具桌上创建一个BEFORE INSERT触发器，该玩具桌上的玩具表记录正在被INSERTED，硬编码ToyAction的信息添加到toytracking表中，该记录将是'INSERT'和插入记录的当前日期和时间。

ERROR 1054: Unknown column 'inserted' in 'NEW' SQL Statement:

CREATE DEFINER = CURRENT_USER TRIGGER `quincyninying`.`toy_BEFORE_INSERT` BEFORE INSERT ON `toy`

FOR EACH ROW

BEGIN

IF new.inserted THEN

SET @toyaction = 'DELETE';

ELSE

SET @toyaction = 'NEW';

END IF;

INSERT INTO `quincyninying`.`toytracking` (toyId, ToyName, ToyCost, Toyaction, ActionDate)

VALUES (new.toyid, new.Toyname, new.Toycost,@Toyaction, now());

END它引发了一个错误，说“错误1054：未知列'插入'新'”