mysql触发器不支持动态sql

BEGIN
  --   CALL Pro_ExcuteSql(new.Id, new.TalentId, new.Weights);
  DECLARE kid INT;

  SET kid = right(new.Id, 1);
  IF kid = 0
    THEN
      INSERT INTO keyindex_0 (Id, KeyId, TalentId, Weights) VALUES (new.Id,new.Id, new.TalentId, new.Weights);
    ELSEIF kid = 1
    THEN
      INSERT INTO keyindex_1 (Id, KeyId, TalentId, Weights) VALUES (new.Id, new.Id, new.TalentId, new.Weights);
    ELSEIF kid = 2
    THEN
      INSERT INTO keyindex_2 (Id, KeyId, TalentId, Weights) VALUES (new.Id, new.Id, new.TalentId, new.Weights);
    ELSEIF kid = 3
    THEN
      INSERT INTO keyindex_3 (Id, KeyId, TalentId, Weights) VALUES (new.Id, new.Id, new.TalentId, new.Weights);
    ELSEIF kid = 4
    THEN
      INSERT INTO keyindex_4 (Id, KeyId, TalentId, Weights) VALUES (new.Id, new.Id, new.TalentId, new.Weights);
    ELSEIF kid = 5
    THEN
      INSERT INTO keyindex_5 (Id, KeyId, TalentId, Weights) VALUES (new.Id, new.Id, new.TalentId, new.Weights);
    ELSEIF kid = 6
    THEN
      INSERT INTO keyindex_6 (Id, KeyId, TalentId, Weights) VALUES (new.Id, new.Id, new.TalentId, new.Weights);
    ELSEIF kid = 7
    THEN
      INSERT INTO keyindex_7 (Id, KeyId, TalentId, Weights) VALUES (new.Id, new.Id, new.TalentId, new.Weights);
    ELSEIF kid = 8
    THEN
      INSERT INTO keyindex_8 (Id, KeyId, TalentId, Weights) VALUES (new.Id, new.Id, new.TalentId, new.Weights);
    ELSEIF kid = 9
    THEN
      INSERT INTO keyindex_9 (Id, KeyId, TalentId, Weights) VALUES (new.Id, new.Id, new.TalentId, new.Weights);
    END IF;
END

什么时候能支持动态sql啊？

搞得触发器成了这个样子：