mysql触发器不支持动态sql

最新推荐文章于 2024-11-13 08:23:13 发布

2401_83916283

最新推荐文章于 2024-11-13 08:23:13 发布

阅读量311

点赞数 3

分类专栏：程序员文章标签： mysql sql javascript

本文链接：https://blog.csdn.net/2401_83916283/article/details/137827308

版权

本文讨论了MySQL触发器不支持动态SQL的限制，通过展示大量的IF-ELSE语句插入不同表的示例，揭示了当@pointid变化时，如何在触发器中针对不同表进行操作的问题，强调了这种做法在实际应用中的局限性。

摘要由CSDN通过智能技术生成

elseif @pointid=93

then

insert into point_93 (sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=94

then

insert into point_94 (sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=95

then

insert into point_95 (sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=96

then

insert into point_96 (sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=97

then

insert into point_97 (sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=98

then

insert into point_98 (sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=99

then

insert into point_99 (sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=100

then

insert into point_100(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=101

then

insert into point_101(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=102

then

insert into point_102(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=103

then

insert into point_103(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=104

then

insert into point_104(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=105

then

insert into point_105(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=106

then

insert into point_106(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=107

then

insert into point_107(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=108

then

insert into point_108(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=109

then

insert into point_109(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=110

then

insert into point_110(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=111

then

insert into point_111(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=112

then

insert into point_112(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=113

then

insert into point_113(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=114

then

insert into point_114(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=115

then

insert into point_115(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=116

then

insert into point_116(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=117

then

insert into point_117(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=118

then

insert into point_118(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=119

then

insert into point_119(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=120

then

insert into point_120(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=121

then

insert into point_121(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=122

then

insert into point_122(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=123

then

insert into point_123(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=124

then

insert into point_124(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=125

then

insert into point_125(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=126

then

insert into point_126(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=127

then

insert into point_127(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=128

then

insert into point_128(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=129

then

insert into point_129(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=130

then

insert into point_130(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=131

then

insert into point_131(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=132

then

insert into point_132(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=133

then

insert into point_133(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=134

then

insert into point_134(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=135

then

insert into point_135(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=136

then

insert into point_136(sqtname,value,datetime,date,time) values(new.sqtname,new.value,new.datetime,DATE_FORMAT( new.datetime, ‘%Y-%m-%d’),DATE_FORMAT( new.datetime, ‘%h:%i:%s’));

elseif @pointid=137