set @num= 1000;
update table set a= @num:=@num+1;
set @date=now();
UPDATE Orders t SET t.CreateTime = (@date:=@date+ INTERVAL 1 HOUR);
mysql 更新数据
欢迎指正：haizi2014@qq.com
set @num= 1000;
update table set a= @num:=@num+1;
set @date=now();
UPDATE Orders t SET t.CreateTime = (@date:=@date+ INTERVAL 1 HOUR);