常用SQL笔记
MySQL
2025-04-08 23:52
阅读:68
评论:0
MySQL之查询20分钟未支付订单
1
2
//status = 0 为未支付状态select * FROM order WHERE TIMESTAMPDIFF(MINUTE,create_date,now()) > 20 AND status = 0;