Question

sql中ifnull()函数在hql中如何使用

Answer 1

SQL Syntax 1:
IFNULL( expression, replacement )
Parameters:
expression
Any expression of any type. This expression is check for NULL.
replacement

The return value if the expression is NULL.

Escape Syntax:
{fn IFNULL( expression, replacement )}
Return Type:
The same as the numeric expression.

SQL SYNTAX 2:
IFNULL( expression )
Return Type:
BOOLEAN

SELECT ifnull( name , '')

Answer 2

另外,虚机团上产品团购,超级便宜