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;