mysql if函数

1. left join表orders，匹配行数为0，表orders以字段全为null的形式存在 

select cus.cust_name,ord.order_num
from customers cus left join orders ord
on cus.cust_id = ord.cust_id and cus.cust_id = 1010;

2. if函数使用，没有as，列名为表达式名

select cus.cust_name,
if(ord.order_num is null,0,ord.order_num) as order_num
from customers cus left join orders ord
on cus.cust_id = ord.cust_id and cus.cust_id = 10001;