# # Show the session value; # SELECT @@session.show_create_table_verbosity; SHOW SESSION VARIABLES LIKE 'show_create_table_verbosity'; --disable_warnings SELECT * FROM performance_schema.session_variables WHERE variable_name='show_create_table_verbosity'; --enable_warnings --echo #Also can be set as a global variable. SELECT @@global.show_create_table_verbosity; SHOW GLOBAL VARIABLES LIKE 'show_create_table_verbosity'; --disable_warnings SELECT * FROM performance_schema.global_variables WHERE variable_name='show_create_table_verbosity'; --enable_warnings --echo #Test setting the variable to various values. --echo #Boolean values. SET SESSION show_create_table_verbosity= ON; SELECT @@session.show_create_table_verbosity; SET SESSION show_create_table_verbosity= OFF; SELECT @@session.show_create_table_verbosity; SET SESSION show_create_table_verbosity= 1; SELECT @@session.show_create_table_verbosity; SET SESSION show_create_table_verbosity= 0; SELECT @@session.show_create_table_verbosity; --echo #Test for DEFAULT value. SET SESSION show_create_table_verbosity= DEFAULT; SELECT @@session.show_create_table_verbosity; --echo #Test for invalid value. --error ER_WRONG_VALUE_FOR_VAR SET SESSION show_create_table_verbosity= 2; --echo #Test for setting the session variable --echo #using different syntax. SET show_create_table_verbosity= 1; --echo #Fetches the current session value for the variable. SELECT @@show_create_table_verbosity; --echo #cleanup SET SESSION show_create_table_verbosity= DEFAULT; --echo #Test setting the global value of the variable. --echo #Boolean values. SET GLOBAL show_create_table_verbosity= ON; SELECT @@global.show_create_table_verbosity; SET GLOBAL show_create_table_verbosity= OFF; SELECT @@global.show_create_table_verbosity; SET GLOBAL show_create_table_verbosity= 1; SELECT @@global.show_create_table_verbosity; SET GLOBAL show_create_table_verbosity= 0; SELECT @@session.show_create_table_verbosity; --echo #Test for DEFAULT value. SET GLOBAL show_create_table_verbosity= DEFAULT; SELECT @@global.show_create_table_verbosity; --echo #Test for invalid value. --error ER_WRONG_VALUE_FOR_VAR SET GLOBAL show_create_table_verbosity= 2;