SELECT
*
FROM
Basestation_info,
Base_station_record
WHERE
Basestation_info.element_name = Base_station_record.element_name
AND TO_DAYS( NOW( ) ) - TO_DAYS( start_time) = 1
mysql 查询昨天的数据
最新推荐文章于 2024-07-10 03:48:24 发布
SELECT
*
FROM
Basestation_info,
Base_station_record
WHERE
Basestation_info.element_name = Base_station_record.element_name
AND TO_DAYS( NOW( ) ) - TO_DAYS( start_time) = 1