我目前的数据
SELECT PROD_CODE FROM `PRODUCT`
是
PROD_CODE
2
5
7
8
22
10
9
11
我try 了所有四个查询，但都没有成功.(Ref)
SELECT CAST(PROD_CODE) AS INT FROM PRODUCT;
SELECT CAST(PROD_CODE AS INT) FROM PRODUCT;
SELECT CAST(PROD_CODE) AS INTEGER FROM PRODUCT;
SELECT CAST(PROD_CODE AS INTEGER) FROM PRODUCT;
所有抛出语法错误如下:
您的SQL语法有错误；查看与您的MySQL服务器版本对应的手册，以获取正确的语法
您的SQL语法有错误；查看手册
What 是 the right syntax to cast varchar to integer in MySQL?
MySQL版本:5.5.16