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.res AS "res",
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',请指教啊~~~~~
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.res AS "res",
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',请指教啊~~~~~
你的语句里又在用双引号又在用单引号。。
在程序里处理这种语句的时候,就有可能因为引号问题,造成语句错误。。
你最好统一一下,只使用一种引号