原文地址为:
mysql varchar类型转换int类型
转载请注明本文地址: mysql varchar类型转换int类型
select * from gyzd_yysinfo order by cast(yysid as SIGNED INTEGER)
或者
select * from gyzd_yysinfo order by cast(yysid as UNSIGNED INTEGER)
转载请注明本文地址: mysql varchar类型转换int类型