mysql / 达梦 / postgreSQL 排序不生效 当排序的字段为字符串时 mysql: order by CAST("字段名" AS SIGNED) asc //如: order by CAST(ID AS SIGNED) asc //或 order by "字段名"*1 asc //或 order by "字段名"+0 asc 达梦 / postgreSQL: order by "字段名"*1 asc //或 order by "字段名"+0 asc //如: order by ID*1 asc