21update_data.mql 969 B

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. /**
  2. sleep(10s)
  3. **/
  4. ;
  5. BEGIN BATCH
  6. update /test/batch set v_int = ?, v_float = ? where v_varchar = ? ;
  7. update /test/batch set v_int = ?, v_float = ? where v_varchar = ? ;
  8. update /test/batch set v_int = ?, v_float = ? where v_varchar = ? ;
  9. update /test/batch set v_int = ?, v_float = ? where v_varchar = ? ;
  10. update /test/batch set v_int = ?, v_float = ? where v_varchar = ? ;
  11. update /test/batch set v_int = ?, v_float = ? where v_varchar = ? ;
  12. update /test/batch set v_int = ?, v_float = ? where v_varchar = ? ;
  13. update /test/batch set v_int = ?, v_float = ? where v_varchar = ? ;
  14. update /test/batch set v_int = ?, v_float = ? where v_varchar = ? ;
  15. update /test/batch set v_int = ?, v_float = ? where v_varchar = ? ;
  16. END
  17. /**
  18. params(1002, 1.2, "4006",
  19. 1003, 1.3, "40",
  20. 1004, 1.4, "400",
  21. 1005, 1.5, "74006",
  22. 1006, 1.6, "409",
  23. 1007, 1.7, "500",
  24. 1008, 1.8, "600",
  25. 1009, 1.9, "700",
  26. 2000, 2.0, "602",
  27. 2001, 2.1, "708")
  28. **/
  29. ;
  30. /**
  31. sleep(10s)
  32. **/
  33. ;