错误方法:convert(int,字段名)或者 cast(字段名 as int) 函数对的,但是这样写完全错误!!!!!
应该 CONVERT(字段名,SIGNED) 或者 CAST(字段名 AS SIGNED integer)
例如:
a、SELECT CAST('123' AS SIGNED integer);标签:语句,CONVERT,int,SIGNED,CAST,SELECT,sql,字符串,字段名 From: https://www.cnblogs.com/hjwbkcom/p/16976089.html
b、SELECT CONVERT('123',SIGNED);