CREATE TRIGGER city2_trigger_insert //创建触发器
after INSERT on city2
FOR EACH ROW
BEGIN
CREATE TABLE IF NOT EXISTS city2_trigger_record( //如果记录表格不存在就创建,保存city2插入后的记录
id INT NOT NULL auto_increment,
manipulateDate datetime,
manipulatePeople VARCHAR(10),
manipulateName VARCHAR(20),
manipulateInfo VARCHAR(40),
readStatus enum('unread','read') NOT NULL DEFAULT 'unread',
PRIMARY KEY (id)
);
DECLARE t_city2_id INT; //15hang
DECLARE t_city2_cityName VARCHAR;
DECLARE t_city2_cityDetial VARCHAR;
DECLARE t_city2_insertInfo VARCHAR;
SET t_city2_id = new.id;
SET t_city2_cityName = new.cityName;
SET t_city2_cityDetial = new.cityDetial;
SET t_city2_insertInfo = CONCAT(t_city2_id, t_city2_cityName, t_city2_cityDetial); //拼接插入哪条信息
INSERT INTO city2_trigger_record VALUES(NOW(),"","insert",CONCAT("insert",t_city2_insertInfo),"unread");
END;
总是提示语法错误,我实在没怎么看出来,求大神们帮帮忙!小弟谢了!!!
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE t_city2_id INT;
DECLARE t_city2_cityName VARCHAR(10);
DECLARE t_city' at line 15