我有触发器语句,但不起作用
CREATE TRIGGER tg_table3_insert BEFORE INSERT ON rd_stonepanel_pricing
FOR EACH ROW BEGIN
INSERT INTO table3_seq VALUES (NULL);
SET NEW.option_id = concat('R',LPAD(LAST_INSERT_ID(),3,'0'));
但是它显示错误,例如您的SQL语法错误:
check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3