您需要在整个SELECt语句周围添加括号
SELECT COUNT (*) FROM mytable
CREATE TRIGGER mytriggerBEFORE INSERT ON mytableBEGIN SELECt CASE WHEN (SELECT COUNT (*) FROM mytable) >= 3 THEN RAISE(FAIL, "Activated - mytrigger.") END;END;
您需要在整个SELECt语句周围添加括号
SELECT COUNT (*) FROM mytable
CREATE TRIGGER mytriggerBEFORE INSERT ON mytableBEGIN SELECt CASE WHEN (SELECT COUNT (*) FROM mytable) >= 3 THEN RAISE(FAIL, "Activated - mytrigger.") END;END;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
