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、查询存储过程...from chkdata;
END
3、查询两个时间之差
select UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP('2018-04-23 14:18:12');
4、添加存储过程...L_Longitude,L_Latitude,L_Elevation,L_LaserHeight,L_FollowHeight,L_PlaneId,L_FlyDate);
/*如果存在编号相同的话num+1;不存在的话值为0...S_EngineRunTime,S_EngineRunUpTime,S_SelfDriveTime,S_FlyTime,S_PlaneId,S_FlyDate);
/*如果存在编号相同的话num+1;不存在的话值为0