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)
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)