mysql datetime、timestamp時間比較 性能提升

• 2020 年 1 月 5 日
• 筆記

1.傳統的方法

SELECT * FROM customer lastlogintime   >=  '2015-01-01 13:50:42'   AND   lastlogintime   <=  '2015-02-06 00:00:00'   ORDER BY ID DESC

但是傳統的方法效率很低。

2.採用UNIX_TIMESTAMP，能有效的提高效率。

SELECT * FROM customer WHERE UNIX_TIMESTAMP(lastlogintime)  >= UNIX_TIMESTAMP('2015-01-01 13:50:42')  AND  UNIX_TIMESTAMP(lastlogintime)  <= UNIX_TIMESTAMP('2015-02-06 00:00:00')  ORDER BY ID DESC