mysql查询最近的数据 发表于 2022-06-20 分类于 mysql DATE_SUB() 函数DATE_SUB(date,INTERVAL expr type) type 值 MICROSECOND SECOND MINUTE HOUR DAY WEEK MONTH QUARTER YEAR 示例select * from xxx_table where create_time > DATE_SUB(NOW(),INTERVAL 1 HOUR);