mysql 触发器应用之向另一个表新增数据

BEGIN
    set @uid  = ( select id from tbl_member where card_id=new.card_id );
    if @uid>0 then
       set @school = (select school from tbl_member where id=@uid );
       insert into tbl_rank_total_score (game_id,uid,school,game_scores,card_id) values ( new.game_id,@uid,@school,new.game_score,new.card_id);
    else
             set @newuid = (select uid from tbl_card_repair where card_id=new.card_id);
             set @school = (select school from tbl_member where id=@newuid );
              insert into tbl_rank_total_score (game_id,uid,school,game_scores,card_id) values ( new.game_id,@newuid,@school,new.game_score,new.card_id);
    end if; 
END