Question

MYSQL的触发器中 变量赋值

CREATE TRIGGER sync_doing BEFORE INSERT ON et_content
FOR EACH ROW BEGIN
SELECT @uc_id:=user_head FROM et_users WHERE user_id=NEW.user_id; //报错！！！
INSERT INTO `school`.`et_content2` (`content_id`, `user_id`, `content_body`, `media_body`, `posttime`, `type`, `filetype`, `retid`, `replyid`, `replytimes`, `zftimes`) VALUES
(null, @uc_id, NEW.content_body, '', 1302966296, '网页', '', 0, 0, 0, 0);
END

怎么在触发器中select赋值变量？？
自己解决了。。。

CREATE TRIGGER `sync_doing` BEFORE INSERT ON `et_content`
FOR EACH ROW BEGIN
declare v_2 varchar(50);
declare v_3 int(10);
set v_2=NEW.content_body;
set v_3=(select user_head FROM `et_users` WHERE user_id=NEW.user_id);
INSERT INTO `et_content2` (`content_id`, `user_id`, `content_body`, `media_body`, `posttime`, `type`, `filetype`, `retid`, `replyid`, `replytimes`, `zftimes`) VALUES
(null, v_3, v_2, '', 1302966296, '网页', '', 0, 0, 0, 0);
END

谁TMD说MYSQL赋值要: 变量要@的！！谁TM的还说MYSQL变量不要声明！！！

Answer 1

SELECT @uc_id=user_head FROM et_users WHERE user_id=NEW.user_id;

追问

#1415 - Not allowed to return a result set from a trigger