mysql中用sql语句创建枚举,总是提示失败!

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
阅读 2.4k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题