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