query_init:
	SET AUTOCOMMIT=OFF ; START TRANSACTION ;

query:
	START TRANSACTION ; update ; COMMIT |
	START TRANSACTION ; insert1 ; COMMIT |
	START TRANSACTION ; insert2 ; ROLLBACK ;

update:
	UPDATE _table SET `int_key` = `int_key` - 20, `int` = `int` + 20 WHERE key_nokey_pk > _digit ;

insert1:
        INSERT INTO _table ( `pk` , `int_key` , `int`) VALUES ( NULL , 100 , 100 ) , ( NULL , 100 , 100 ) ;

insert2:
        INSERT INTO _table ( `pk` ) VALUES ( NULL ) , ( NULL ) , ( NULL ) ; ROLLBACK ;

key_nokey_pk:
	`int_key` | `int` | `pk` ;

_digit:
	1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 ;