转载:https://blog.csdn.net/c_henjinxing521/article/details/51788963
select MAX(CAST(userNo as SIGNED INTEGER)) from userInfo ;
或者
select MAX(CAST(userNo as UNSIGNED INTEGER)) from userInfo ;
————varchar 转 int
cast(id as signed integer) 或者 cast(id as unsigned integer)
---------------------