mysql decimal和double 在round四舍五入的问题

2019独角兽企业重金招聘Python工程师标准>>>

CREATE TABLE `testtable` (
  `id` int(11) NOT NULL,
  `pricedec` decimal(20,3) NOT NULL,
  `amount` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `testtable` (`id`, `pricedec`, `amount`) VALUES (1, 2.165, 2.165);

INSERT INTO `testtable` (`id`, `pricedec`, `amount`) VALUES (2, 2.115, 2.115);

SELECT pricedec,ROUND(pricedec,2),amount,ROUND(amount,2)  from  testtable

---------------------------------------------------------------------

amount double 类型

ROUND(amount,2) ---》2.165四舍五入之后 不对

转载于:https://my.oschina.net/lsl1991/blog/1616278