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