SELECT
a.id AS "id",
IFNULL(a.route_id, "") AS "busId",
IFNULL(a.route_name, "") AS "name",
IFNULL(a.route_name_ext, "") AS "nameExt",
IFNULL(a.sort, "") AS "sort",
IFNULL(a.route_mapping_name, "") AS "routeMappingName",
a.route_mapping AS "routeMapping",
a.create_by AS "createBy.id",
a.create_date AS "createDate",
a.update_by AS "updateBy.id",
a.update_date AS "updateDate",
a.remarks AS "remarks",
a.del_flag AS "delFlag"
FROM
bus_route a
WHERE a.del_flag = '0'
ORDER BY cast(a.sort AS DECIMAL) DESC
上面的一條sql，IFNULL陳述句在我本地（windows 7 mysql-5.7.24）能正常運行，但是在服務器（Linux mysql-5.7.24）會報錯，
[Err] 1054 - Unknown column '' in 'field list'，請指教啊~~~~~
uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
有人可以指教一下嗎~~~~~~~~~uj5u.com熱心網友回復：
你這個錯誤和IFNULL沒有關系吧。。你的陳述句里又在用雙引號又在用單引號。。
在程式里處理這種陳述句的時候，就有可能因為引號問題，造成陳述句錯誤。。
你最好統一一下，只使用一種引號
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/49967.html
標籤：MySQL