我想問一下
select * from a where time between ('2020-01-01) and ('2020-10-10') and ss=1
select * from a where time between '2020-01-01' and '2020-10-10' and ss=1
select * from a where (time between '2020-01-01' and '2020-10-10') and ss=1
這三句一樣嘛
另外,用between and 和<>,執行效率一樣嗎?
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/195469.html
標籤:MySQL
上一篇:galera cluster報錯
下一篇:如何成為一個機器人工程師
