mysql触发器不支持动态sql

最新推荐文章于 2021-01-27 23:29:21 发布

一包烟电脑面前做一天

最新推荐文章于 2021-01-27 23:29:21 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

文章标签： mysql sql 大数据

本文链接：https://blog.youkuaiyun.com/MrTraum/article/details/22161533

本文探讨了如何在特定条件下使用SQL插入语句优化数据库操作，通过触发器根据输入ID的最后一位进行不同表的插入操作，实现了针对不同数据结构的高效管理。同时，文章提出对SQL功能的期待，希望能实现动态SQL的支持，以提高数据库操作的灵活性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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啊？

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