mysql 触发器定义变量_声明变量MySQL触发器

我的问题对你来说可能很简单，如果你习惯了MySQL。我习惯于PostgreSQL SGBD，我正在尝试将PL/PgSQL脚本翻译成MySQL。声明变量MySQL触发器

以下是我有：

delimiter //

CREATE TRIGGER pgl_new_user

AFTER INSERT ON users FOR EACH ROW

BEGIN

DECLARE m_user_team_id integer;

SELECT id INTO m_user_team_id FROM user_teams WHERE name = "pgl_reporters";

DECLARE m_projects_id integer;

DECLARE cur CURSOR FOR SELECT project_id FROM user_team_project_relationships WHERE user_team_id = m_user_team_id;

OPEN cur;

ins_loop: LOOP

FETCH cur INTO m_projects_id;

IF done THEN

LEAVE ins_loop;

END IF;

INSERT INTO users_projects (user_id, project_id, created_at, updated_at, project_access)

VALUES (NEW.id, m_projects_id, now(), now(), 20);

END LOOP;

CLOSE cur;

END//

但MySQL工作台给我一个错误的DECLARE m_projects_id。我不太明白，因为我的指令同上面两行......

任何提示？

编辑：neubert解决了这个错误。谢谢。

不过不失，当我尝试插入到用户：

Error Code: 1329. No data - zero rows fetched, selected, or processed

你有什么想法？或者更好的，你知道我怎么能得到一个更好的错误信息？

2013-04-05

Arthur

+1

看看这里：http://dba.stackexchange.com/questions/25405/event-scheduler-no-data-zero-rows-fetched-selected-or-processed –

2013-04-22 06:05:24