MYSQL好像不支持计算字段吧?价格触发器DELIMITER ;;CREATE TRIGGER `dd` BEFORE INSERT ON `temp` FOR EACH ROW set NEW.dis_price = CONCAT(substring('
',1,9-length(CAST(round(new.price*new.discount/10,2) AS char))),CAST(round(new.price*new.discount/10,2) AS char));;DELIMITER ;...