Lines Matching refs:UPDATE
336 # cmd An UPDATE command to execute against table t1
342 1 {} {} UPDATE 1 {6 7 8 9} 1
343 2 REPLACE {} UPDATE 0 {7 6 9} 1
344 3 IGNORE {} UPDATE 0 {6 7 3 9} 1
345 4 FAIL {} UPDATE 1 {6 7 3 4} 1
346 5 ABORT {} UPDATE 1 {1 2 3 4} 1
347 6 ROLLBACK {} UPDATE 1 {1 2 3 4} 0
348 7 REPLACE {} {UPDATE OR IGNORE} 0 {6 7 3 9} 1
349 8 IGNORE {} {UPDATE OR REPLACE} 0 {7 6 9} 1
350 9 FAIL {} {UPDATE OR IGNORE} 0 {6 7 3 9} 1
351 10 ABORT {} {UPDATE OR REPLACE} 0 {7 6 9} 1
352 11 ROLLBACK {} {UPDATE OR IGNORE} 0 {6 7 3 9} 1
353 12 {} {} {UPDATE OR IGNORE} 0 {6 7 3 9} 1
354 13 {} {} {UPDATE OR REPLACE} 0 {7 6 9} 1
355 14 {} {} {UPDATE OR FAIL} 1 {6 7 3 4} 1
356 15 {} {} {UPDATE OR ABORT} 1 {1 2 3 4} 1
357 16 {} {} {UPDATE OR ROLLBACK} 1 {1 2 3 4} 0
358 17 {} IGNORE UPDATE 0 {6 7 3 9} 1
359 18 {} REPLACE UPDATE 0 {7 6 9} 1
360 19 {} FAIL UPDATE 1 {6 7 3 4} 1
361 20 {} ABORT UPDATE 1 {1 2 3 4} 1
362 21 {} ROLLBACK UPDATE 1 {1 2 3 4} 0
363 22 REPLACE IGNORE UPDATE 0 {6 7 3 9} 1
364 23 IGNORE REPLACE UPDATE 0 {7 6 9} 1
365 24 REPLACE FAIL UPDATE 1 {6 7 3 4} 1
366 25 IGNORE ABORT UPDATE 1 {1 2 3 4} 1
367 26 REPLACE ROLLBACK UPDATE 1 {1 2 3 4} 0
377 UPDATE t3 SET x=0;
409 UPDATE OR IGNORE t1 SET a=1000;
428 UPDATE OR REPLACE t1 SET a=1001;
536 UPDATE t2 SET a=a+1 WHERE a=1;
548 UPDATE t2 SET b=b+1 WHERE b=1;
555 UPDATE t3 SET x=x+1;
567 UPDATE t3 SET x=x+1;
568 UPDATE t2 SET b=b+1 WHERE b=1;
584 UPDATE t2 SET d=d+1 WHERE d=1;
591 UPDATE t3 SET x=x+1;
603 UPDATE t3 SET x=x+1;
604 UPDATE t2 SET d=d+1 WHERE d=1;
620 UPDATE t2 SET e=e+1 WHERE e=1;
627 UPDATE t3 SET x=x+1;
639 UPDATE t3 SET x=x+1;
640 UPDATE t2 SET e=e+1 WHERE e=1;
656 UPDATE t2 SET c=c-1 WHERE c=2;
663 UPDATE t3 SET x=x+1;