1SET @global_start_value = @@global.innodb_autoinc_lock_mode; 2SELECT @global_start_value; 3@global_start_value 41 5'#--------------------FN_DYNVARS_046_01------------------------#' 6SET @@global.innodb_autoinc_lock_mode = 0; 7ERROR HY000: Variable 'innodb_autoinc_lock_mode' is a read only variable 8SET @@global.innodb_autoinc_lock_mode = DEFAULT; 9ERROR HY000: Variable 'innodb_autoinc_lock_mode' is a read only variable 10SELECT @@global.innodb_autoinc_lock_mode; 11@@global.innodb_autoinc_lock_mode 121 13'#---------------------FN_DYNVARS_046_02-------------------------#' 14SELECT @@innodb_autoinc_lock_mode; 15@@innodb_autoinc_lock_mode 161 17SELECT local.innodb_autoinc_lock_mode; 18ERROR 42S02: Unknown table 'local' in field list 19SELECT @@global.innodb_autoinc_lock_mode; 20@@global.innodb_autoinc_lock_mode 211 22'#----------------------FN_DYNVARS_046_03------------------------#' 23SELECT @@global.innodb_autoinc_lock_mode = VARIABLE_VALUE 24FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 25WHERE VARIABLE_NAME='innodb_autoinc_lock_mode'; 26@@global.innodb_autoinc_lock_mode = VARIABLE_VALUE 271 28SELECT @@global.innodb_autoinc_lock_mode; 29@@global.innodb_autoinc_lock_mode 301 31SELECT VARIABLE_VALUE 32FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 33WHERE VARIABLE_NAME='innodb_autoinc_lock_mode'; 34VARIABLE_VALUE 351 36