SET @a = 0;
UPDATE `tb_bhp_old` t SET t.ONE = @a:=@a+1;
SELECT @date;
UPDATE `tb_bhp_old` t SET t.`collectDate` = (@date:=@date+ INTERVAL 1 HOUR)
UPDATE `tb_bhp_old` t SET t.ONE = @a:=@a+1;
SELECT @date;
UPDATE `tb_bhp_old` t SET t.`collectDate` = (@date:=@date+ INTERVAL 1 HOUR)