360SDN.COM

首页/MySQL/列表

mysql varchar类型转换int类型(整数类型)

来源:  2018-09-25 15:29:59    评论:0点击:

select * from t_table order by cast(id as SIGNED INTEGER)

或者

select * from t_table order by cast(id as UNSIGNED INTEGER)


为您推荐

友情链接 |九搜汽车网 |手机ok生活信息网|ok生活信息网|ok微生活
 Powered by www.360SDN.COM   京ICP备11022651号-4 © 2012-2016 版权