1select @@global.last_insert_id; 2ERROR HY000: Variable 'last_insert_id' is a SESSION variable 3select @@session.last_insert_id; 4@@session.last_insert_id 50 6show global variables like 'last_insert_id'; 7Variable_name Value 8show session variables like 'last_insert_id'; 9Variable_name Value 10last_insert_id 0 11select * from information_schema.global_variables where variable_name='last_insert_id'; 12VARIABLE_NAME VARIABLE_VALUE 13select * from information_schema.session_variables where variable_name='last_insert_id'; 14VARIABLE_NAME VARIABLE_VALUE 15LAST_INSERT_ID 0 16set global last_insert_id=99; 17ERROR HY000: Variable 'last_insert_id' is a SESSION variable and can't be used with SET GLOBAL 18set session last_insert_id=42; 19select @@global.last_insert_id; 20ERROR HY000: Variable 'last_insert_id' is a SESSION variable 21select @@session.last_insert_id; 22@@session.last_insert_id 2342 24show global variables like 'last_insert_id'; 25Variable_name Value 26show session variables like 'last_insert_id'; 27Variable_name Value 28last_insert_id 42 29select * from information_schema.global_variables where variable_name='last_insert_id'; 30VARIABLE_NAME VARIABLE_VALUE 31select * from information_schema.session_variables where variable_name='last_insert_id'; 32VARIABLE_NAME VARIABLE_VALUE 33LAST_INSERT_ID 42 34set session last_insert_id=1.1; 35ERROR 42000: Incorrect argument type to variable 'last_insert_id' 36set session last_insert_id=1e1; 37ERROR 42000: Incorrect argument type to variable 'last_insert_id' 38set session last_insert_id="foo"; 39ERROR 42000: Incorrect argument type to variable 'last_insert_id' 40