数据可视化时因为数据类型排序无效的问题：这是由于你要排序的类型是String类型的而ORDER BY 方法排序要求整数型。
这就需要在ORDER BY 后加 CAST(需要排序的字段 AS UNSIGNED)如下：
SELECT ip0,sumtraffic FROM data2 ORDER BY CAST(sumtraffic AS UNSIGNED) DESC limit 10标签：语句,sumtraffic,UNSIGNED,CAST,sql,排序,ORDER From： https://www.cnblogs.com/jyt604743080/p/16811099.html