mysql中varchar类型使用sum函数，计算相应的小数点后几位

 

1、建表

CREATE TABLE `test` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `output_value` varchar(20) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB   DEFAULT CHARSET=utf8mb4;


INSERT INTO `test` VALUES (1, '12.12');
INSERT INTO `test` VALUES (2, '12.12');
INSERT INTO `test` VALUES (3, '12.12');
INSERT INTO `test` VALUES (4, '12.12');
INSERT INTO `test` VALUES (5, '12.12');

 

2、添加几条数据

 

3、测试

 

 select sum(output_value) from test;

select sum(cast(output_value as DECIMAL(10,2))) from test;

select sum(CONVERT(output_value,DECIMAL(10,2))) from test;