一条语句系列——sql（不定期更新）

select *
from newstable
where abs(datediff(sysdate(), pubtime))<=1 Order by pubtime Desc limit 100;

INSERT INTO table1 (id, name) VALUES (1, 'record1') ON DUPLICATE KEY UPDATE name = 'record1';