1、添加存储过程
DELIMITER //
CREATE PROCEDURE AddLLdata(
in L_Longitude double ,
in L_Latitude double,
IN...,L_Latitude,L_Elevation,L_LaserHeight,L_FollowHeight,L_PlaneId,L_FlyDate);
END //
DELIMITER ;
2、查询存储过程...TaskChkAbeamSpeed,TaskChkFixTime,TaskChkMaxFF
,TaskChkTaskCode,PlaneId,FlyDate from chkdata;
END
3、查询两个时间之差...select UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP('2018-04-23 14:18:12');
4、添加存储过程(两张表的添加和修改双重判断判断)
CREATE...exists(select * from Copter where PlaneId=E_PlaneId);
/*如果num大于0则代表存在*/
if (num>0)
THEN
/*如果存在的话,判断时间