mysql 有空值的列怎么使用索引

最新推荐文章于 2024-08-09 03:59:26 发布

baidu_41788306

最新推荐文章于 2024-08-09 03:59:26 发布

阅读量611

点赞数

文章标签： sql mysql 数据库

本文链接：https://blog.csdn.net/baidu_41788306/article/details/116229259

版权

文章目录

MySQL 有空值的列能用索引吗

MySQL 有空值的列能用索引吗

MySQL可以用，有相应的优化

https://dev.mysql.com/doc/refman/5.6/en/is-null-optimization.html

MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = constant_value. For example, MySQL can use indexes and ranges to search for NULL with IS NULL.

Examples

SELECT * FROM tbl_name WHERE key_col IS NULL;
SELECT * FROM tbl_name WHERE key_col <=> NULL;
SELECT * FROM tbl_name WHERE key_col=const1 OR key_col=const2 OR key_col IS NULL;