Mike's Learn & Fun

撰寫順序 /***************** * SELECT ******************/ -- 選取所有員工資料 SELECT * FROM `emp` ; -- 選取所有員工的 員工編號, 姓名, 性別 SELECT EmpID, Name, Gender FROM emp SELECT EmpID, Name, IF(Gender=0, "男", "女") FROM emp SELECT EmpID, Name, IF(Gender=0, "男", "女") AS Gender2 FROM emp -- 選取所有員工的 員工編號, 姓名+職稱, 性別 SELECT EmpID, concat(Name, " ", Title, " ", IF(gender=0, "先生", "小姐")), Gender FROM emp