MySQL错误代码:1193.未知的系统变量 [英] MySQL Error Code: 1193. Unknown system variable

问题描述

好，所以我正在研究触发器，它告诉我(MySQL Workbench 5.2)无法识别此变量.
*错误代码:1193.未知系统变量error_msg_3 *

Ok so i'm working on triggers, and it tells me it(MySQL workbench 5.2) doesn't recognize this variable.
*Error Code: 1193. Unknown system variable error_msg_3*

我认为在触发器中使用它是正确的，请帮助我

I think it would be correct using it in a trigger, please help me

CREATE TRIGGER controlla_MaxCARDINALITA_INSERT
BEFORE INSERT ON SENTIERO__HA__TAPPA
FOR EACH ROW 
BEGIN

DECLARE max_cardinalita INTEGER;
DECLARE error_msg_3 CONDITION FOR SQLSTATE '99003';

SELECT COUNT(*) into max_cardinalita
FROM SENTIERO__HA__TAPPA
WHERE IDsentiero=NEW.IDsentiero;

IF max_cardinalita>=10 THEN
        SIGNAL error_msg_3;
        SET error_msg_3='INSERT: Il sentiero ha già il massimo numero di tappe consentito';

END IF;

END$$

:

我尝试了这个，看起来很正常

I tried this, and it seems working

DECLARE msg VARCHAR(255);
set msg = concat('MyTriggerError: Trying to insert a negative value in trigger_test: ');
signal sqlstate '45000' set message_text = msg;

推荐答案

根据

According to MySQL docs, the error #1193 occurs when you use wrong code for SQLSTATE.

消息:未知系统变量％s

Message: Unknown system variable %s

而且，正如您在同一页面上所看到的，则未定义SQLSTATE 99003.

And, as you can see on the same page, the SQLSTATE 99003 is not defined.

这篇关于MySQL错误代码:1193.未知的系统变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！