devbox
爱喝兽奶帝天荒
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

mysql触发器不支持动态sql_触发器中不允许使用动态sql

作者：爱喝兽奶帝天荒 | 2024-06-25 21:32:06

赞

踩

触发器中不允许使用动态sql
  1. drop trigger if exists tri_*
  2. DELIMITER //
  3. create trigger tri_* before update
  4. on pointtable for each row
  5. begin
  6.    if exists (select pointname from pointtable where pointname=new.pointname)
  7.     then
  8.         select pointtable,pointid into @pointtablename,@pointid from pointtable where pointname = new.pointname;
  9.         if @pointid=1
  10. 			then
  11. 				insert into point_1(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'));
  12. 		    elseif @pointid=2
  13.             then
  14.     			insert into point_2(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'));
  15.     		elseif @pointid=3   
  16.     		then
  17.     		  insert into point_3  (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'));
  18.     		elseif @pointid=4   
  19.     		then
  20.     		  insert into point_4  (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'));
  21.     		elseif @pointid=5   
  22.     		then
  23.     		  insert into point_5  (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'));
  24.     		elseif @pointid=6   
  25.     		then
  26.     		  insert into point_6  (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'));
  27.     		elseif @pointid=7   
  28.     		then
  29.     		  insert into point_7  (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'));
  30.     		elseif @pointid=8   
  31.     		then
  32.     		  insert into point_8  (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'));
  33.     		elseif @pointid=9   
  34.     		then
  35.     		  insert into point_9  (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'));
  36.     		elseif @pointid=10  
  37.     		then
  38.     		  insert into point_10 (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'));
  39.     		elseif @pointid=11  
  40.     		then
  41.     		  insert into point_11 (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'));
  42.     		elseif @pointid=12  
  43.     		then
  44.     		  insert into point_12 (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'));
  45.     		elseif @pointid=13  
  46.     		then
  47.     		  insert into point_13 (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'));
  48.     		elseif @pointid=14  
  49.     		then
  50.     		  insert into point_14 (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'));
  51.     		elseif @pointid=15  
  52.     		then
  53.     		  insert into point_15 (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'));
  54.     		elseif @pointid=16  
  55.     		then
  56.     		  insert into point_16 (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'));
  57.     		elseif @pointid=17  
  58.     		then
  59.     		  insert into point_17 (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'));
  60.     		elseif @pointid=18  
  61.     		then
  62.     		  insert into point_18 (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'));
  63.     		elseif @pointid=19  
  64.     		then
  65.     		  insert into point_19 (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'));
  66.     		elseif @pointid=20  
  67.     		then
  68.     		  insert into point_20 (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'));
  69.     		elseif @pointid=21  
  70.     		then
  71.     		  insert into point_21 (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'));
  72.     		elseif @pointid=22  
  73.     		then
  74.     		  insert into point_22 (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'));
  75.     		elseif @pointid=23  
  76.     		then
  77.     		  insert into point_23 (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'));
  78.     		elseif @pointid=24  
  79.     		then
  80.     		  insert into point_24 (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'));
  81.     		elseif @pointid=25  
  82.     		then
  83.     		  insert into point_25 (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'));
  84.     		elseif @pointid=26  
  85.     		then
  86.     		  insert into point_26 (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'));
  87.     		elseif @pointid=27  
  88.     		then
  89.     		  insert into point_27 (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'));
  90.     		elseif @pointid=28  
  91.     		then
  92.     		  insert into point_28 (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'));
  93.     		elseif @pointid=29  
  94.     		then
  95.     		  insert into point_29 (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'));
  96.     		elseif @pointid=30  
  97.     		then
  98.     		  insert into point_30 (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'));
  99.     		elseif @pointid=31  
  100.     		then
  101.     		  insert into point_31 (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'));
  102.     		elseif @pointid=32  
  103.     		then
  104.     		  insert into point_32 (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'));
  105.     		elseif @pointid=33  
  106.     		then
  107.     		  insert into point_33 (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'));
  108.     		elseif @pointid=34  
  109.     		then
  110.     		  insert into point_34 (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'));
  111.     		elseif @pointid=35  
  112.     		then
  113.     		  insert into point_35 (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'));
  114.     		elseif @pointid=36  
  115.     		then
  116.     		  insert into point_36 (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'));
  117.     		elseif @pointid=37  
  118.     		then
  119.     		  insert into point_37 (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'));
  120.     		elseif @pointid=38  
  121.     		then
  122.     		  insert into point_38 (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'));
  123.     		elseif @pointid=39  
  124.     		then
  125.     		  insert into point_39 (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'));
  126.     		elseif @pointid=40  
  127.     		then
  128.     		  insert into point_40 (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'));
  129.     		elseif @pointid=41  
  130.     		then
  131.     		  insert into point_41 (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'));
  132.     		elseif @pointid=42  
  133.     		then
  134.     		  insert into point_42 (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'));
  135.     		elseif @pointid=43  
  136.     		then
  137.     		  insert into point_43 (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'));
  138.     		elseif @pointid=44  
  139.     		then
  140.     		  insert into point_44 (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'));
  141.     		elseif @pointid=45  
  142.     		then
  143.     		  insert into point_45 (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'));
  144.     		elseif @pointid=46  
  145.     		then
  146.     		  insert into point_46 (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'));
  147.     		elseif @pointid=47  
  148.     		then
  149.     		  insert into point_47 (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'));
  150.     		elseif @pointid=48  
  151.     		then
  152.     		  insert into point_48 (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'));
  153.     		elseif @pointid=49  
  154.     		then
  155.     		  insert into point_49 (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'));
  156.     		elseif @pointid=50  
  157.     		then
  158.     		  insert into point_50 (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'));
  159.     		elseif @pointid=51  
  160.     		then
  161.     		  insert into point_51 (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'));
  162.     		elseif @pointid=52  
  163.     		then
  164.     		  insert into point_52 (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'));
  165.     		elseif @pointid=53  
  166.     		then
  167.     		  insert into point_53 (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'));
  168.     		elseif @pointid=54  
  169.     		then
  170.     		  insert into point_54 (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'));
  171.     		elseif @pointid=55  
  172.     		then
  173.     		  insert into point_55 (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'));
  174.     		elseif @pointid=56  
  175.     		then
  176.     		  insert into point_56 (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'));
  177.     		elseif @pointid=57  
  178.     		then
  179.     		  insert into point_57 (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'));
  180.     		elseif @pointid=58  
  181.     		then
  182.     		  insert into point_58 (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'));
  183.     		elseif @pointid=59  
  184.     		then
  185.     		  insert into point_59 (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'));
  186.     		elseif @pointid=60  
  187.     		then
  188.     		  insert into point_60 (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'));
  189.     		elseif @pointid=61  
  190.     		then
  191.     		  insert into point_61 (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'));
  192.     		elseif @pointid=62  
  193.     		then
  194.     		  insert into point_62 (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'));
  195.     		elseif @pointid=63  
  196.     		then
  197.     		  insert into point_63 (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'));
  198.     		elseif @pointid=64  
  199.     		then
  200.     		  insert into point_64 (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'));
  201.     		elseif @pointid=65  
  202.     		then
  203.     		  insert into point_65 (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'));
  204.     		elseif @pointid=66  
  205.     		then
  206.     		  insert into point_66 (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'));
  207.     		elseif @pointid=67  
  208.     		then
  209.     		  insert into point_67 (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'));
  210.     		elseif @pointid=68  
  211.     		then
  212.     		  insert into point_68 (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'));
  213.     		elseif @pointid=69  
  214.     		then
  215.     		  insert into point_69 (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'));
  216.     		elseif @pointid=70  
  217.     		then
  218.     		  insert into point_70 (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'));
  219.     		elseif @pointid=71  
  220.     		then
  221.     		  insert into point_71 (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'));
  222.     		elseif @pointid=72  
  223.     		then
  224.     		  insert into point_72 (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'));
  225.     		elseif @pointid=73  
  226.     		then
  227.     		  insert into point_73 (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'));
  228.     		elseif @pointid=74  
  229.     		then
  230.     		  insert into point_74 (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'));
  231.     		elseif @pointid=75  
  232.     		then
  233.     		  insert into point_75 (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'));
  234.     		elseif @pointid=76  
  235.     		then
  236.     		  insert into point_76 (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'));
  237.     		elseif @pointid=77  
  238.     		then
  239.     		  insert into point_77 (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'));
  240.     		elseif @pointid=78  
  241.     		then
  242.     		  insert into point_78 (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'));
  243.     		elseif @pointid=79  
  244.     		then
  245.     		  insert into point_79 (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'));
  246.     		elseif @pointid=80  
  247.     		then
  248.     		  insert into point_80 (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'));
  249.     		elseif @pointid=81  
  250.     		then
  251.     		  insert into point_81 (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'));
  252.     		elseif @pointid=82  
  253.     		then
  254.     		  insert into point_82 (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'));
  255.     		elseif @pointid=83  
  256.     		then
  257.     		  insert into point_83 (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'));
  258.     		elseif @pointid=84  
  259.     		then
  260.     		  insert into point_84 (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'));
  261.     		elseif @pointid=85  
  262.     		then
  263.     		  insert into point_85 (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'));
  264.     		elseif @pointid=86  
  265.     		then
  266.     		  insert into point_86 (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'));
  267.     		elseif @pointid=87  
  268.     		then
  269.     		  insert into point_87 (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'));
  270.     		elseif @pointid=88  
  271.     		then
  272.     		  insert into point_88 (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'));
  273.     		elseif @pointid=89  
  274.     		then
  275.     		  insert into point_89 (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'));
  276.     		elseif @pointid=90  
  277.     		then
  278.     		  insert into point_90 (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'));
  279.     		elseif @pointid=91  
  280.     		then
  281.     		  insert into point_91 (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'));
  282.     		elseif @pointid=92  
  283.     		then
  284.     		  insert into point_92 (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'));
  285.     		elseif @pointid=93  
  286.     		then
  287.     		  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'));
  288.     		elseif @pointid=94  
  289.     		then
  290.     		  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'));
  291.     		elseif @pointid=95  
  292.     		then
  293.     		  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'));
  294.     		elseif @pointid=96  
  295.     		then
  296.     		  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'));
  297.     		elseif @pointid=97  
  298.     		then
  299.     		  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'));
  300.     		elseif @pointid=98  
  301.     		then
  302.     		  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'));
  303.     		elseif @pointid=99  
  304.     		then
  305.     		  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'));
  306.     		elseif @pointid=100 
  307.     		then
  308.     		  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'));
  309.     		elseif @pointid=101 
  310.     		then
  311.     		  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'));
  312.     		elseif @pointid=102 
  313.     		then
  314.     		  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'));
  315.     		elseif @pointid=103 
  316.     		then
  317.     		  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'));
  318.     		elseif @pointid=104 
  319.     		then
  320.     		  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'));
  321.     		elseif @pointid=105 
  322.     		then
  323.     		  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'));
  324.     		elseif @pointid=106 
  325.     		then
  326.     		  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'));
  327.     		elseif @pointid=107 
  328.     		then
  329.     		  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'));
  330.     		elseif @pointid=108 
  331.     		then
  332.     		  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'));
  333.     		elseif @pointid=109 
  334.     		then
  335.     		  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'));
  336.     		elseif @pointid=110 
  337.     		then
  338.     		  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'));
  339.     		elseif @pointid=111 
  340.     		then
  341.     		  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'));
  342.     		elseif @pointid=112 
  343.     		then
  344.     		  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'));
  345.     		elseif @pointid=113 
  346.     		then
  347.     		  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'));
  348.     		elseif @pointid=114 
  349.     		then
  350.     		  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'));
  351.     		elseif @pointid=115 
  352.     		then
  353.     		  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'));
  354.     		elseif @pointid=116 
  355.     		then
  356.     		  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'));
  357.     		elseif @pointid=117 
  358.     		then
  359.     		  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'));
  360.     		elseif @pointid=118 
  361.     		then
  362.     		  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'));
  363.     		elseif @pointid=119 
  364.     		then
  365.     		  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'));
  366.     		elseif @pointid=120 
  367.     		then
  368.     		  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'));
  369.     		elseif @pointid=121 
  370.     		then
  371.     		  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'));
  372.     		elseif @pointid=122 
  373.     		then
  374.     		  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'));
  375.     		elseif @pointid=123 
  376.     		then
  377.     		  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'));
  378.     		elseif @pointid=124 
  379.     		then
  380.     		  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'));
  381.     		elseif @pointid=125 
  382.     		then
  383.     		  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'));
  384.     		elseif @pointid=126 
  385.     		then
  386.     		  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'));
  387.     		elseif @pointid=127 
  388.     		then
  389.     		  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'));
  390.     		elseif @pointid=128 
  391.     		then
  392.     		  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'));
  393.     		elseif @pointid=129 
  394.     		then
  395.     		  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'));
  396.     		elseif @pointid=130 
  397.     		then
  398.     		  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'));
  399.     		elseif @pointid=131 
  400.     		then
  401.     		  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'));
  402.     		elseif @pointid=132 
  403.     		then
  404.     		  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'));
  405.     		elseif @pointid=133 
  406.     		then
  407.     		  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'));
  408.     		elseif @pointid=134 
  409.     		then
  410.     		  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'));
  411.     		elseif @pointid=135 
  412.     		then
  413.     		  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'));
  414.     		elseif @pointid=136 
  415.     		then
  416.     		  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'));
  417.     		elseif @pointid=137 
  418.     		then
  419.     		  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'));
  420.     		elseif @pointid=138 
  421.     		then
  422.     		  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'));
  423.     		elseif @pointid=139 
  424.     		then
  425.     		  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'));
  426.     		elseif @pointid=140 
  427.     		then
  428.     		  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'));
  429.     		elseif @pointid=141 
  430.     		then
  431.     		  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'));
  432.     		elseif @pointid=142 
  433.     		then
  434.     		  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'));
  435.     		elseif @pointid=143 
  436.     		then
  437.     		  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'));
  438.     		elseif @pointid=144 
  439.     		then
  440.     		  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'));
  441.     		elseif @pointid=145 
  442.     		then
  443.     		  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'));
  444.     		elseif @pointid=146 
  445.     		then
  446.     		  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'));
  447.     		elseif @pointid=147 
  448.     		then
  449.     		  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'));
  450.     		elseif @pointid=148 
  451.     		then
  452.     		  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'));
  453.     		elseif @pointid=149 
  454.     		then
  455.     		  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'));
  456.     		elseif @pointid=150 
  457.     		then
  458.     		  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'));
  459.     		elseif @pointid=151 
  460.     		then
  461.     		  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'));
  462.     		elseif @pointid=152 
  463.     		then
  464.     		  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'));
  465.     		elseif @pointid=153 
  466.     		then
  467.     		  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'));
  468.     		elseif @pointid=154 
  469.     		then
  470.     		  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'));
  471.     		elseif @pointid=155 
  472.     		then
  473.     		  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'));
  474.     		elseif @pointid=156 
  475.     		then
  476.     		  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'));
  477.     		elseif @pointid=157 
  478.     		then
  479.     		  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'));
  480.     		elseif @pointid=158 
  481.     		then
  482.     		  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'));
  483.     		elseif @pointid=159 
  484.     		then
  485.     		  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'));
  486.     		elseif @pointid=160 
  487.     		then
  488.     		  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'));
  489.     		elseif @pointid=161 
  490.     		then
  491.     		  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'));
  492.     		elseif @pointid=162 
  493.     		then
  494.     		  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'));
  495.     		elseif @pointid=163 
  496.     		then
  497.     		  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'));
  498.     		elseif @pointid=164 
  499.     		then
  500.     		  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'));
  501.     		elseif @pointid=165 
  502.     		then
  503.     		  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'));
  504.     		elseif @pointid=166 
  505.     		then
  506.     		  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'));
  507.     		elseif @pointid=167 
  508.     		then
  509.     		  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'));
  510.     		elseif @pointid=168 
  511.     		then
  512.     		  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'));
  513.     		elseif @pointid=169 
  514.     		then
  515.     		  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'));
  516.     		elseif @pointid=170 
  517.     		then
  518.     		  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'));
  519.     		elseif @pointid=171 
  520.     		then
  521.     		  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'));
  522.     		elseif @pointid=172 
  523.     		then
  524.     		  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'));
  525.     		elseif @pointid=173 
  526.     		then
  527.     		  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'));
  528.     		elseif @pointid=174 
  529.     		then
  530.     		  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'));
  531.     		elseif @pointid=175 
  532.     		then
  533.     		  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'));
  534.     		elseif @pointid=176 
  535.     		then
  536.     		  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'));
  537.     		elseif @pointid=177 
  538.     		then
  539.     		  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'));
  540.     		elseif @pointid=178 
  541.     		then
  542.     		  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'));
  543.     		elseif @pointid=179 
  544.     		then
  545.     		  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'));
  546.     		elseif @pointid=180 
  547.     		then
  548.     		  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'));
  549.     		elseif @pointid=181 
  550.     		then
  551.     		  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'));
  552.     		elseif @pointid=182 
  553.     		then
  554.     		  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'));
  555.     		elseif @pointid=183 
  556.     		then
  557.     		  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'));
  558.     		elseif @pointid=184 
  559.     		then
  560.     		  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'));
  561.     		elseif @pointid=185 
  562.     		then
  563.     		  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'));
  564.     		elseif @pointid=186 
  565.     		then
  566.     		  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'));
  567.     		elseif @pointid=187 
  568.     		then
  569.     		  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'));
  570.     		elseif @pointid=188 
  571.     		then
  572.     		  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'));
  573.     		elseif @pointid=189 
  574.     		then
  575.     		  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'));
  576.     		elseif @pointid=190 
  577.     		then
  578.     		  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'));
  579.     		elseif @pointid=191 
  580.     		then
  581.     		  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'));
  582.     		elseif @pointid=192 
  583.     		then
  584.     		  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'));
  585.     		elseif @pointid=193 
  586.     		then
  587.     		  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'));
  588.     		elseif @pointid=194 
  589.     		then
  590.     		  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'));
  591.     		elseif @pointid=195 
  592.     		then
  593.     		  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'));
  594.     		elseif @pointid=196 
  595.     		then
  596.     		  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'));
  597.     		elseif @pointid=197 
  598.     		then
  599.     		  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'));
  600.     		elseif @pointid=198 
  601.     		then
  602.     		  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'));
  603.     		elseif @pointid=199 
  604.     		then
  605.     		  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'));
  606.     		elseif @pointid=200 
  607.     		then
  608.     		  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'));
  609.     		elseif @pointid=201 
  610.     		then
  611.     		  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'));
  612.     		elseif @pointid=202 
  613.     		then
  614.     		  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'));
  615.     		elseif @pointid=203 
  616.     		then
  617.     		  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'));
  618.     		elseif @pointid=204 
  619.     		then
  620.     		  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'));
  621.     		elseif @pointid=205 
  622.     		then
  623.     		  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'));
  624.     		elseif @pointid=206 
  625.     		then
  626.     		  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'));
  627.     		elseif @pointid=207 
  628.     		then
  629.     		  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'));
  630.     		elseif @pointid=208 
  631.     		then
  632.     		  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'));
  633.     		elseif @pointid=209 
  634.     		then
  635.     		  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'));
  636.     		elseif @pointid=210 
  637.     		then
  638.     		  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'));
  639.     		elseif @pointid=211 
  640.     		then
  641.     		  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'));
  642.     		elseif @pointid=212 
  643.     		then
  644.     		  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'));
  645.     		elseif @pointid=213 
  646.     		then
  647.     		  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'));
  648.     		elseif @pointid=214 
  649.     		then
  650.     		  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'));
  651.     		elseif @pointid=215 
  652.     		then
  653.     		  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'));
  654.     		elseif @pointid=216 
  655.     		then
  656.     		  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'));
  657.     		elseif @pointid=217 
  658.     		then
  659.     		  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'));
  660.     		elseif @pointid=218 
  661.     		then
  662.     		  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'));
  663.     		elseif @pointid=219 
  664.     		then
  665.     		  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'));
  666.     		elseif @pointid=220 
  667.     		then
  668.     		  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'));
  669.     		elseif @pointid=221 
  670.     		then
  671.     		  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'));
  672.     		elseif @pointid=222 
  673.     		then
  674.     		  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'));
  675.     		elseif @pointid=223 
  676.     		then
  677.     		  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'));
  678.     		elseif @pointid=224 
  679.     		then
  680.     		  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'));
  681.     		elseif @pointid=225 
  682.     		then
  683.     		  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'));
  684.     		elseif @pointid=226 
  685.     		then
  686.     		  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'));
  687.     		elseif @pointid=227 
  688.     		then
  689.     		  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'));
  690.     		elseif @pointid=228 
  691.     		then
  692.     		  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'));
  693.     		elseif @pointid=229 
  694.     		then
  695.     		  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'));
  696.     		elseif @pointid=230 
  697.     		then
  698.     		  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'));
  699.     		elseif @pointid=231 
  700.     		then
  701.     		  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'));
  702.     		elseif @pointid=232 
  703.     		then
  704.     		  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'));
  705.     		elseif @pointid=233 
  706.     		then
  707.     		  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'));
  708.     		elseif @pointid=234 
  709.     		then
  710.     		  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'));
  711.     		elseif @pointid=235 
  712.     		then
  713.     		  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'));
  714.     		elseif @pointid=236 
  715.     		then
  716.     		  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'));
  717.     		elseif @pointid=237 
  718.     		then
  719.     		  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'));
  720.     		elseif @pointid=238 
  721.     		then
  722.     		  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'));
  723.     		elseif @pointid=239 
  724.     		then
  725.     		  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'));
  726.     		elseif @pointid=240 
  727.     		then
  728.     		  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'));
  729.     		elseif @pointid=241 
  730.     		then
  731.     		  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'));
  732.     		elseif @pointid=242 
  733.     		then
  734.     		  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'));
  735.     		elseif @pointid=243 
  736.     		then
  737.     		  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'));
  738.     		elseif @pointid=244 
  739.     		then
  740.     		  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'));
  741.     		elseif @pointid=245 
  742.     		then
  743.     		  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'));
  744.     		elseif @pointid=246 
  745.     		then
  746.     		  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'));
  747.     		elseif @pointid=247 
  748.     		then
  749.     		  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'));
  750.     		elseif @pointid=248 
  751.     		then
  752.     		  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'));
  753.     		elseif @pointid=249 
  754.     		then
  755.     		  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'));
  756.     		elseif @pointid=250 
  757.     		then
  758.     		  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'));
  759.     		elseif @pointid=251 
  760.     		then
  761.     		  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'));
  762.     		elseif @pointid=252 
  763.     		then
  764.     		  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'));
  765.     		elseif @pointid=253 
  766.     		then
  767.     		  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'));
  768.     		elseif @pointid=254 
  769.     		then
  770.     		  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'));
  771.     		elseif @pointid=255 
  772.     		then
  773.     		  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'));
  774.     		elseif @pointid=256 
  775.     		then
  776.     		  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'));
  777.     		elseif @pointid=257 
  778.     		then
  779.     		  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'));
  780.     		elseif @pointid=258 
  781.     		then
  782.     		  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'));
  783.     		elseif @pointid=259 
  784.     		then
  785.     		  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'));
  786.     		elseif @pointid=260 
  787.     		then
  788.     		  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'));
  789.     		elseif @pointid=261 
  790.     		then
  791.     		  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'));
  792.     		elseif @pointid=262 
  793.     		then
  794.     		  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'));
  795.     		elseif @pointid=263 
  796.     		then
  797.     		  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'));
  798.     		elseif @pointid=264 
  799.     		then
  800.     		  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'));
  801.     		elseif @pointid=265 
  802.     		then
  803.     		  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'));
  804.     		elseif @pointid=266 
  805.     		then
  806.     		  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'));
  807.     		elseif @pointid=267 
  808.     		then
  809.     		  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'));
  810.     		elseif @pointid=268 
  811.     		then
  812.     		  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'));
  813.     		elseif @pointid=269 
  814.     		then
  815.     		  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'));
  816.     		elseif @pointid=270 
  817.     		then
  818.     		  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'));
  819.     		elseif @pointid=271 
  820.     		then
  821.     		  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'));
  822.     		elseif @pointid=272 
  823.     		then
  824.     		  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'));
  825.     		elseif @pointid=273 
  826.     		then
  827.     		  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'));
  828.     		elseif @pointid=274 
  829.     		then
  830.     		  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'));
  831.     		elseif @pointid=275 
  832.     		then
  833.     		  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'));
  834.     		elseif @pointid=276 
  835.     		then
  836.     		  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'));
  837.     		elseif @pointid=277 
  838.     		then
  839.     		  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'));
  840.     		elseif @pointid=278 
  841.     		then
  842.     		  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'));
  843.     		elseif @pointid=279 
  844.     		then
  845.     		  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'));
  846.     		elseif @pointid=280 
  847.     		then
  848.     		  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'));
  849.     		elseif @pointid=281 
  850.     		then
  851.     		  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'));
  852.     		elseif @pointid=282 
  853.     		then
  854.     		  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'));
  855.     		elseif @pointid=283 
  856.     		then
  857.     		  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'));
  858.     		elseif @pointid=284 
  859.     		then
  860.     		  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'));
  861.     		elseif @pointid=285 
  862.     		then
  863.     		  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'));
  864.     		elseif @pointid=286 
  865.     		then
  866.     		  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'));
  867.     		elseif @pointid=287 
  868.     		then
  869.     		  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'));
  870.     		elseif @pointid=288 
  871.     		then
  872.     		  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'));
  873.     		elseif @pointid=289 
  874.     		then
  875.     		  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'));
  876.     		elseif @pointid=290 
  877.     		then
  878.     		  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'));
  879.     		elseif @pointid=291 
  880.     		then
  881.     		  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'));
  882.     		elseif @pointid=292 
  883.     		then
  884.     		  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'));
  885.     		elseif @pointid=293 
  886.     		then
  887.     		  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'));
  888.     		elseif @pointid=294 
  889.     		then
  890.     		  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'));
  891.     		elseif @pointid=295 
  892.     		then
  893.     		  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'));
  894.     		elseif @pointid=296 
  895.     		then
  896.     		  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'));
  897.     		elseif @pointid=297 
  898.     		then
  899.     		  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'));
  900.     		elseif @pointid=298 
  901.     		then
  902.     		  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'));
  903.     		elseif @pointid=299 
  904.     		then
  905.     		  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'));
  906.     		elseif @pointid=300 
  907.     		then
  908.     		  insert into point_300(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'));
  909.     end if;
  910. end;
  911. //
  912. DELIMITER ;


声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/爱喝兽奶帝天荒/article/detail/757425
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号