错误 #1109 - 由触发器引起的字段列表中的未知表 [英] Error #1109 - unknown table in field list caused by trigger

问题描述

这是我的触发器.

我想在 1 张桌子 (pelayanan) 上制作触发器.

I want to make trigger on 1 table (pelayanan).

CREATE DEFINER=`root`@`localhost` TRIGGER `before_insert_pelayanan` 
BEFORE INSERT ON `pelayanan` FOR EACH ROW 
IF NEW.`ESTIMASI` IS NULL OR NEW.`ESTIMASI` = 0 AND
    `dbhpl`.`pelayanan`.`DAYA` <= 5500 
    THEN SET NEW.ESTIMASI = 4; 
ELSEIF NEW.ESTIMASI IS NULL OR NEW.ESTIMASI = 0 AND
    `dbhpl`.`pelayanan`.`DAYA` <= 33000 AND 
    `dbhpl`.`pelayanan`.`DAYA` >= 6600 
    THEN SET NEW.ESTIMASI = 15; 
ELSEIF NEW.ESTIMASI IS NULL OR NEW.ESTIMASI = 0 AND
   `dbhpl`.`pelayanan`.`DAYA` <= 197000 AND 
   `dbhpl`.`pelayanan`.`DAYA` >= 41500 
    THEN SET NEW.ESTIMASI = 40; 
ELSE SET NEW.ESTIMASI = 100; 
END IF

当我执行触发器时，它已被创建.但是，当我将数据插入表 pelayanan 时，它变成了

When I execute the trigger, it has been created. But, when I insert data into table pelayanan, It become

#1109 - 字段列表中的未知表 'pelayanan'.

#1109 - Unknown table 'pelayanan' in field list.

我该如何解决这个问题?

How can I resolve this?

我必须删除dbhpl.pelayanan.DAYA 成为pelayanan.DAYA 和DAYA.但是，它不起作用.

I have to remove dbhpl.pelayanan.DAYA become pelayanan.DAYA and DAYA. But, It doesn't work.

推荐答案

在列名前使用 NEW.这是正确的代码-

use NEW before column name. This is the right code-

mysql>
    CREATE DEFINER=`root`@`localhost` TRIGGER `before_insert_pelayanan`
    BEFORE INSERT ON `pelayanan` FOR EACH ROW 
        IF NEW.`ESTIMASI` IS NULL OR NEW.`ESTIMASI` = 0 AND
            `NEW`.`DAYA` <= 5500 
            THEN SET NEW.ESTIMASI = 4; 
        ELSEIF NEW.ESTIMASI IS NULL OR NEW.ESTIMASI = 0 AND
            `NEW`.`DAYA` <= 33000 AND 
            `NEW`.`DAYA` >= 6600 
            THEN SET NEW.ESTIMASI = 15; 
        ELSEIF NEW.ESTIMASI IS NULL OR NEW.ESTIMASI = 0 AND
           `NEW`.`DAYA` <= 197000 AND 
           `NEW`.`DAYA` >= 41500 
            THEN SET NEW.ESTIMASI = 40; 
        ELSE SET NEW.ESTIMASI = 100; 
    END IF

Query OK, 0 rows affected (0.11 sec)

mysql> insert into pelayanan values ();
Query OK, 1 row affected (0.08 sec)

mysql> select * from pelayanan ;
+----------+------+
| ESTIMASI | daya |
+----------+------+
| 4        | NULL |
+----------+------+
1 row in set (0.00 sec)

这篇关于错误 #1109 - 由触发器引起的字段列表中的未知表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！