1、添加存储过程
DELIMITER //
CREATE PROCEDURE AddLLdata(
in L_Longitude double ,
in L_Latitude double,
IN...values(L_Longitude,L_Latitude,L_Elevation,L_LaserHeight,L_FollowHeight,L_PlaneId,L_FlyDate);
END //
DELIMITER...;
2、查询存储过程
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetAllchkdata`()
LANGUAGE SQL
NOT DETERMINISTIC...from chkdata;
END
3、查询两个时间之差
select UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP('2018-04-23 14:18:12');
4、添加存储过程...,substring_index(OverTime,' ',-1)),'%Y-%m-%d %T:%f');
END //
DELIMITER ;