多了一对引号
改为:
SELECT TIME_TO_SEC( NOW( ) ) - TIME_TO_SEC( time_at )
FROM `counter`
WHERE ip = '10.0.0.1'
AND name = 'hxhp2'
ORDER BY TIME_TO_SEC(NOW())-TIME_TO_SEC(time_at) ASC
改为:
SELECT TIME_TO_SEC( NOW( ) ) - TIME_TO_SEC( time_at )
FROM `counter`
WHERE ip = '10.0.0.1'
AND name = 'hxhp2'
ORDER BY TIME_TO_SEC(NOW())-TIME_TO_SEC(time_at) ASC
什么东东?学习
问题解决了 ^_^
to:楼上 TIME_TO_SEC是把时间转换成秒的函数。