查询数据库中最新的一条记录
1 | SELECT id FROM affair ORDER BY create_time DESC LIMIT 0,1; |
删除这条最新的记录
1 | DELETE a FROM affair a,(SELECT id FROM affair b ORDER BY b.create_time DESC LIMIT 0,1) b WHERE a.id = b.id; |
DELETE a 指的是后面 affair a，子select查询结果重命名为b了。
删除数据库中最新一条记录
mysql
