什么是mysql的"BETWEEN"?性能超过..? [英] What's mysql's "BETWEEN" performance over..?

问题描述

在(尤其是)以下mysql中进行查询时，是否有更好的性能:

Is there any better performance when querying in (particularly) mysql of the following:

SELECT * FROM `table` WHERE `unix_date` BETWEEN 1291736700 AND 1291737300

结束:

SELECT * FROM `table` WHERE `unix_date` >= 1291736700 AND `unix_date` <= 1291737300

还是BETWEEN语法仅被第二个sql代替?

or BETWEEN syntax is just being substituted with the second sql?

推荐答案

我记得没有什么区别.但是，请自己检查是否:

As I recall, there's no difference. But see for yourself if:

explain plan for 
SELECT * FROM `table` WHERE `unix_date` BETWEEN 1291736700 AND 1291737300

和:

explain plan for
SELECT * FROM `table` WHERE `unix_date` >= 1291736700 AND `unix_date` <= 1291737300

产生相同的计划.

这篇关于什么是mysql的"BETWEEN"?性能超过..?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！