PROGRAMMING

 
REMEMBERS




Last update:   29-10-2021

Example

Set a default value to cover fields that are NULL.
 
SELECT IFNULL(catg, 'n/a') FROM catg
-> n/a
    
 
SELECT IF(catg IS NULL, 'n/a', catg) FROM catg
-> n/a 
    

Questions    
Union

        A B C D E F
🔔
1/2