不是的,我可能没表达清楚我的意思是说某一条记录的某个属性值按增涨参数增涨就好比不停的 update test set columnA=columnA+100 where id="123"
用触发器吧drop trigger if exists Trg_Update_A; DELIMITER $$ CREATE TRIGGER Trg_Update_A AFTER UPDATE on A FOR EACH ROW BEGIN new.field= old.field + new.step;END$$DELIMITER ;
`ID` int(11) NOT NULL auto_increment,
PRIMARY KEY (`ID`)
)
DELIMITER $$
CREATE TRIGGER Trg_Update_A AFTER UPDATE on A
FOR EACH ROW
BEGIN new.field= old.field + new.step;END$$DELIMITER ;