1'#--------------------FN_DYNVARS_039_01-------------------------#' 2SET global innodb_autoinc_lock_mode = 1; 3ERROR HY000: Variable 'innodb_autoinc_lock_mode' is a read only variable 4'--innodb_autoinc_lock_mode is 1 (consecutive)--' 5SELECT @@global.innodb_autoinc_lock_mode; 6@@global.innodb_autoinc_lock_mode 71 8DROP TABLE IF EXISTS t1; 9CREATE TABLE t1( 10a INT AUTO_INCREMENT PRIMARY KEY, 11b CHAR 12) ENGINE=INNODB, AUTO_INCREMENT=100; 13INSERT INTO t1 (a,b) VALUES (5,'a'), (NULL,'b'), (1,'c'), (NULL,'d'); 14INSERT INTO t1 (a,b) VALUES (NULL,'e'); 15'the new auto incremented value should be 104' 16SELECT * FROM t1; 17a b 181 c 195 a 20100 b 21101 d 22104 e 23DROP TABLE t1; 24