查询表中最后五条记录
(按某一字段降序取前五条)
SELECT * FROM table ORDER BY created DESC LIMIT 5
根据日期(年月日)查询
select * from call_loan_info where DATE_FORMAT(create_time,’%Y-%m-%d’) = ‘2017-06-16’
查询表中最后五条记录
(按某一字段降序取前五条)
SELECT * FROM table ORDER BY created DESC LIMIT 5
根据日期(年月日)查询
select * from call_loan_info where DATE_FORMAT(create_time,’%Y-%m-%d’) = ‘2017-06-16’