select * from gyzd_yysinfo order by cast(yysid as SIGNED INTEGER)
或者
select * from gyzd_yysinfo order by cast(yysid as UNSIGNED INTEGER)
本文转自yunlielai51CTO博客，原文链接：http://blog.51cto.com/4925054/1830728，如需转载请自行联系原作者
select * from gyzd_yysinfo order by cast(yysid as SIGNED INTEGER)
或者
select * from gyzd_yysinfo order by cast(yysid as UNSIGNED INTEGER)
本文转自yunlielai51CTO博客，原文链接：http://blog.51cto.com/4925054/1830728，如需转载请自行联系原作者
![数据迁移方法数据迁移原则数据迁移之双写方案数据迁移之级联同步方案[图]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)