Navicat mysql 从一张表往另外一张表定时插入数据
首先创建一个函数CREATE DEFINER=root@% PROCEDURE mypro()beginINSERT INTO t_group_bbsj_hour(ACC_AVG_XA,ACC_AVG_ZR,ACC_VP_XA,ACC_VP_ZR,Per,Run,SFT_VP_XA,Temp,Vol,CJSJ,CODE) SELECT ACC_AVG_XA,ACC_AVG_ZR,ACC_VP_XA,ACC_VP_ZR,Per,Run,SFT_VP_XA,Temp,Vol,CJSJ,CODE from
原创
2020-05-22 14:36:01 ·
1583 阅读 ·
0 评论