原因在于要改成int才行:
MYSQL 查询代码如下:
select name from a_table where cast(age as UNSIGNED INTEGER)>cast(work_age as UNSIGNED INTEGER) order by id
原因在于要改成int才行:
MYSQL 查询代码如下:
select name from a_table where cast(age as UNSIGNED INTEGER)>cast(work_age as UNSIGNED INTEGER) order by id