MySQL condition functions

Functions in MySQL for writing conditions.

IF

IF(condition_expression, true_expression, false_expression)

Returns the firt expression if it is not null. In case of null, it returns the second argument.

IFNULL(test_if_null, null_value);

>SELECT IFNULL('test', 'it is NULL');
'test'
>SELECT IFNULL(NULL, 'it is NULL');
'it is NULL'

Odkaz na článek

Vytvořil 25. prosince 2014 v 11:34:17 mira. Upravováno 1x, naposledy 25. prosince 2014 v 11:38:17, mira