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
then
insert into point_137(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=138
then
insert into point_138(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=139
then
insert into point_139(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=140
then
insert into point_140(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=141
then
insert into point_141(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=142
then
insert into point_142(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=143
then
insert into point_143(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=144
then
insert into point_144(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=145
then
insert into point_145(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=146
then
insert into point_146(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=147
then
insert into point_147(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=148
then
insert into point_148(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=149
then
insert into point_149(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=150
then
insert into point_150(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=151
then
insert into point_151(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=152
then
insert into point_152(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=153
then
insert into point_153(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=154
then
insert into point_154(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=155
then
insert into point_155(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=156
then
insert into point_156(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=157
then
insert into point_157(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=158
then
insert into point_158(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=159
then
insert into point_159(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=160
then
insert into point_160(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=161
then
insert into point_161(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=162
then
insert into point_162(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=163
then
insert into point_163(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=164
then
insert into point_164(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=165
then
insert into point_165(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=166
then
insert into point_166(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=167
then
insert into point_167(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=168
then
insert into point_168(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=169
then
insert into point_169(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=170
then
insert into point_170(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=171
then
insert into point_171(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=172
then
insert into point_172(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=173
then
insert into point_173(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=174
then
insert into point_174(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=175
then
insert into point_175(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=176
then
insert into point_176(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=177
then
insert into point_177(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=178
then
insert into point_178(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=179
then
insert into point_179(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=180
then
insert into point_180(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=181
then
insert into point_181(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=182
then
insert into point_182(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=183
then
insert into point_183(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=184
then
insert into point_184(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=185
then
insert into point_185(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=186
then
insert into point_186(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=187
then
insert into point_187(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=188
then
insert into point_188(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=189
then
insert into point_189(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=190
then
insert into point_190(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=191
then
insert into point_191(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=192
then
insert into point_192(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=193
then
insert into point_193(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=194
then
insert into point_194(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=195
then
insert into point_195(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=196
then
insert into point_196(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=197
then
insert into point_197(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=198
then
insert into point_198(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=199
then
insert into point_199(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=200
then
insert into point_200(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=201
then
insert into point_201(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=202
then
insert into point_202(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=203
then
insert into point_203(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=204
then
insert into point_204(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=205
then
insert into point_205(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=206
then
insert into point_206(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=207
then
insert into point_207(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=208
then
insert into point_208(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=209
then
insert into point_209(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=210
then
insert into point_210(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=211
then
insert into point_211(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=212
then
insert into point_212(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=213
then
insert into point_213(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=214
then
insert into point_214(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=215
then
insert into point_215(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=216
then
insert into point_216(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=217
then
insert into point_217(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=218
then
insert into point_218(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=219
then
insert into point_219(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=220
then
insert into point_220(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=221
then
insert into point_221(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=222
then
insert into point_222(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=223
then
insert into point_223(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=224
then
insert into point_224(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=225
then
insert into point_225(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=226
then
insert into point_226(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=227
then
insert into point_227(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=228
then
insert into point_228(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=229
then
insert into point_229(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=230
then
insert into point_230(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=231
then
insert into point_231(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=232
then
insert into point_232(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=233
then
insert into point_233(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=234
then
insert into point_234(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=235
then
insert into point_235(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=236
then
insert into point_236(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=237
then
insert into point_237(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=238
then
insert into point_238(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=239
then
insert into point_239(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=240
then
insert into point_240(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=241
then
insert into point_241(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=242
then
insert into point_242(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=243
then
insert into point_243(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=244
then
insert into point_244(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=245
then
insert into point_245(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=246
then
insert into point_246(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=247
then
insert into point_247(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=248
then
insert into point_248(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=249
then
insert into point_249(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=250
then
insert into point_250(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=251
then
insert into point_251(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=252
then
insert into point_252(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=253
then
insert into point_253(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=254
then
insert into point_254(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=255
then
insert into point_255(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=256
then
insert into point_256(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=257
then
insert into point_257(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=258
then
insert into point_258(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=259
then
insert into point_259(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=260
then
insert into point_260(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=261
then
insert into point_261(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=262
then
insert into point_262(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=263
then
insert into point_263(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=264
then
insert into point_264(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=265
then
insert into point_265(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=266
then
insert into point_266(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=267
then
insert into point_267(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=268
then
insert into point_268(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=269
then
insert into point_269(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=270
then
insert into point_270(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=271
then
insert into point_271(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=272
then
insert into point_272(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=273
then
insert into point_273(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=274
then
insert into point_274(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=275
then
insert into point_275(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=276
then
insert into point_276(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=277
then
insert into point_277(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=278
then
insert into point_278(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=279
then
insert into point_279(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=280
then
insert into point_280(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=281
then
insert into point_281(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=282
then
insert into point_282(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=283
then
insert into point_283(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=284
then
insert into point_284(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=285
then
insert into point_285(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=286
then
insert into point_286(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=287
then
insert into point_287(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=288
then
insert into point_288(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=289
then
insert into point_289(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=290
then
insert into point_290(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=291
then
insert into point_291(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=292
then
insert into point_292(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=293
then
insert into point_293(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=294
then
insert into point_294(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=295
then
insert into point_295(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=296
then
insert into point_296(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=297
then
insert into point_297(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=298
then
insert into point_298(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=299
then
insert into point_299(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’));
最后
自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。
深知大多数Java工程师,想要提升技能,往往是自己摸索成长,自己不成体系的自学效果低效漫长且无助。
因此收集整理了一份《2024年Java开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上Java开发知识点,不论你是刚入门Java开发的新手,还是希望在技术上不断提升的资深开发者,这些资料都将为你打开新的学习之门!
如果你觉得这些内容对你有帮助,需要这份全套学习资料的朋友可以戳我获取!!
由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新!
);
elseif @pointid=297
then
insert into point_297(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=298
then
insert into point_298(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=299
then
insert into point_299(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’));
最后
自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。
深知大多数Java工程师,想要提升技能,往往是自己摸索成长,自己不成体系的自学效果低效漫长且无助。
因此收集整理了一份《2024年Java开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
[外链图片转存中…(img-29J7rUzo-1715852108670)]
[外链图片转存中…(img-hHeo0VRP-1715852108671)]
[外链图片转存中…(img-oM5QKR0O-1715852108671)]
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上Java开发知识点,不论你是刚入门Java开发的新手,还是希望在技术上不断提升的资深开发者,这些资料都将为你打开新的学习之门!
如果你觉得这些内容对你有帮助,需要这份全套学习资料的朋友可以戳我获取!!
由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新!