mysql计算两个字段的百分比

CREATE TABLE `testnum` (
  `a` varchar(255) DEFAULT NULL,
  `b` varchar(255) DEFAULT NULL,
  `c` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

  

select CONCAT(ROUND(a/b*100,2),"%") from testnum;

  

原文地址:https://www.cnblogs.com/torchstar/p/14971256.html