问题遇到的现象和发生背景
cvs文件导入MYSQL后
用SELECT MAX(金额),MIN(金额) from sheet1;查询sheet1表的最大值和最小值,显示结果不对
问题相关代码,请勿粘贴截图
SELECT MAX(金额),MIN(金额) from sheet1;
cvs文件导入MYSQL后
用SELECT MAX(金额),MIN(金额) from sheet1;查询sheet1表的最大值和最小值,显示结果不对
SELECT MAX(金额),MIN(金额) from sheet1;
SELECT MAX(CAST(金额 AS DECIMAL)),MIN(CAST(金额 AS DECIMAL)) from sheet1;