45 测试

update product set updateddatetime=date_add(updateddatetime,interval 1 second)

 

begin;
update productorder set orderNo='20092815530687971100' where id=2;
update productorder set orderNo='20092815530687971101' where id=2;
update productorder set orderNo='20092815530687971102' where id=2;
update productorder set orderNo='20092815530687971103' where id=2;
update productorder set orderNo='20092815530687971104' where id=2;
update productorder set orderNo='20092815530687971100' where id=2;
update productorder set orderNo='20092815530687971101' where id=2;
update productorder set orderNo='20092815530687971102' where id=2;
update productorder set orderNo='20092815530687971103' where id=2;
update productorder set orderNo='20092815530687971104' where id=2;
update productorder set orderNo='20092815530687971100' where id=2;
update productorder set orderNo='20092815530687971101' where id=2;
update productorder set orderNo='20092815530687971102' where id=2;
update productorder set orderNo='20092815530687971103' where id=2;
update productorder set orderNo='20092815530687971104' where id=2;
commit;