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、添加存储过程...DATETIME
)
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
/*定义一个变量存储是否存在的值...values(S_PlaneId,S_FlyTime,S_EngineRunTime,S_EngineRunUpTime,S_SelfDriveTime);
end if;
END
**字符串转时间格式