MySql数据库常用SQL语句
1、查询出更新时间减去创建时间大于15分钟的记录
SELECT * FROM table WHERE (unix_timestamp(update_time)- unix_timestamp(create_time))>900;
2、查询超N分钟后还是某种状态的订单
SELECT * FROM table WHERE status = 0 and update_time < DATE_SUB(NOW(), INTERVAL 60 MINUTE) ;
3、查询表中两列时间差值加和再求平均值
SELECT SUM(TIMESTAMPDIFF(SECOND, CREATE_TIME, UPDATE_TIME)) DIV COUNT(1) as Average, COUNT(*) as total FROM TABLE1