"IS NULL"与"IS NULL"之间的区别在于:和"ISNULL()"；在Mysql中 [英] Differences between "IS NULL" and "ISNULL()" in Mysql

问题描述

运算符IS NULL和函数ISNULL()之间的性能是否存在差异?

Is there any difference in performance between the operator IS NULL and the function ISNULL()?

推荐答案

在MySQL手册中，它们似乎确实是同义词.

Looking into the MySQL manual, they seem to be synonyms really.

• 关于

ISNULL()上的MySQL手册

MySQL manual on ISNULL()

即使不是，我也会倾向于相信查询优化器来选择最佳解决方案.

and even if they aren't, I would tend to trust the query optimizer to pick the best solution.

这篇关于"IS NULL"与"IS NULL"之间的区别在于:和"ISNULL()"；在Mysql中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！