mysql在触发器中怎么定义变量,声明变量MySQL触发器

My question might be simple for you, if you're used to MySQL. I'm used to PostgreSQL SGBD and I'm trying to translate a PL/PgSQL script to MySQL.

Here is what I have :

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);