1SET @start_value = @@session.insert_id; 2SELECT @start_value; 3@start_value 40 5'#--------------------FN_DYNVARS_051_01------------------------#' 6SET @@session.insert_id = 99; 7'Variable is giving error on assigning Default value'; 8SELECT @@session.insert_id; 9@@session.insert_id 1099 11'#---------------------FN_DYNVARS_051_02-------------------------#' 12SET @@session.insert_id = @start_value; 13SELECT @@session.insert_id = 0; 14@@session.insert_id = 0 151 16'#--------------------FN_DYNVARS_051_03------------------------#' 17SET @@session.insert_id = 0; 18SELECT @@session.insert_id; 19@@session.insert_id 200 21SET @@session.insert_id = 1099; 22SELECT @@session.insert_id; 23@@session.insert_id 241099 25SET @@session.insert_id = 1800; 26SELECT @@session.insert_id; 27@@session.insert_id 281800 29SET @@session.insert_id = 65535; 30SELECT @@session.insert_id; 31@@session.insert_id 3265535 33'#--------------------FN_DYNVARS_051_04-------------------------#' 34SET @@session.insert_id = -1; 35Warnings: 36Warning 1292 Truncated incorrect insert_id value: '-1' 37SELECT @@session.insert_id; 38@@session.insert_id 390 40SET @@session.insert_id = 100000000000; 41SELECT @@session.insert_id; 42@@session.insert_id 43100000000000 44SET @@session.insert_id = 10000.01; 45ERROR 42000: Incorrect argument type to variable 'insert_id' 46SELECT @@session.insert_id; 47@@session.insert_id 48100000000000 49SET @@session.insert_id = -1024; 50Warnings: 51Warning 1292 Truncated incorrect insert_id value: '-1024' 52SELECT @@session.insert_id; 53@@session.insert_id 540 55SET @@session.insert_id = 42949672950; 56SELECT @@session.insert_id; 57@@session.insert_id 5842949672950 59SET @@session.insert_id = ON; 60ERROR 42000: Incorrect argument type to variable 'insert_id' 61SELECT @@session.insert_id; 62@@session.insert_id 6342949672950 64SET @@session.insert_id = 'test'; 65ERROR 42000: Incorrect argument type to variable 'insert_id' 66SELECT @@session.insert_id; 67@@session.insert_id 6842949672950 69'#-------------------FN_DYNVARS_051_05----------------------------#' 70SET @@global.insert_id = 0; 71ERROR HY000: Variable 'insert_id' is a SESSION variable and can't be used with SET GLOBAL 72SELECT @@global.insert_id; 73ERROR HY000: Variable 'insert_id' is a SESSION variable 74'#----------------------FN_DYNVARS_051_06------------------------#' 75SELECT @@global.insert_id = VARIABLE_VALUE 76FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 77WHERE VARIABLE_NAME='insert_id'; 78ERROR HY000: Variable 'insert_id' is a SESSION variable 79SELECT @@session.insert_id = VARIABLE_VALUE 80FROM INFORMATION_SCHEMA.SESSION_VARIABLES 81WHERE VARIABLE_NAME='insert_id'; 82@@session.insert_id = VARIABLE_VALUE 831 84'#-------------------FN_DYNVARS_051_07----------------------------#' 85SET @@global.insert_id = 0; 86ERROR HY000: Variable 'insert_id' is a SESSION variable and can't be used with SET GLOBAL 87SELECT @@global.insert_id; 88ERROR HY000: Variable 'insert_id' is a SESSION variable 89'#---------------------FN_DYNVARS_051_08----------------------#' 90SET @@session.insert_id = TRUE; 91SELECT @@session.insert_id; 92@@session.insert_id 931 94SET @@session.insert_id = FALSE; 95SELECT @@session.insert_id; 96@@session.insert_id 970 98'#---------------------FN_DYNVARS_051_09----------------------#' 99SET @@session.insert_id = 1; 100SELECT @@insert_id = @@session.insert_id; 101@@insert_id = @@session.insert_id 1021 103SELECT @@session.insert_id = @@local.insert_id; 104@@session.insert_id = @@local.insert_id 1051 106'#---------------------FN_DYNVARS_051_10----------------------#' 107SET insert_id = 1; 108SELECT @@insert_id; 109@@insert_id 1101 111SET local.insert_id = 1; 112ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.insert_id = 1' at line 1 113SELECT local.insert_id; 114ERROR 42S02: Unknown table 'local' in field list 115SET session.insert_id = 1; 116ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'session.insert_id = 1' at line 1 117SELECT session.insert_id; 118ERROR 42S02: Unknown table 'session' in field list 119SELECT insert_id = @@session.insert_id; 120ERROR 42S22: Unknown column 'insert_id' in 'field list' 121SET @@session.insert_id = @start_value; 122SELECT @@session.insert_id; 123@@session.insert_id 1240 125