1SELECT @@session.show_create_table_verbosity; 2@@session.show_create_table_verbosity 30 4SHOW SESSION VARIABLES LIKE 'show_create_table_verbosity'; 5Variable_name Value 6show_create_table_verbosity OFF 7SELECT * FROM information_schema.session_variables WHERE variable_name='show_create_table_verbosity'; 8VARIABLE_NAME VARIABLE_VALUE 9SHOW_CREATE_TABLE_VERBOSITY OFF 10#Also can be set as a global variable. 11SELECT @@global.show_create_table_verbosity; 12@@global.show_create_table_verbosity 130 14SHOW GLOBAL VARIABLES LIKE 'show_create_table_verbosity'; 15Variable_name Value 16show_create_table_verbosity OFF 17SELECT * FROM information_schema.global_variables WHERE variable_name='show_create_table_verbosity'; 18VARIABLE_NAME VARIABLE_VALUE 19SHOW_CREATE_TABLE_VERBOSITY OFF 20#Test setting the variable to various values. 21#Boolean values. 22SET SESSION show_create_table_verbosity= ON; 23SELECT @@session.show_create_table_verbosity; 24@@session.show_create_table_verbosity 251 26SET SESSION show_create_table_verbosity= OFF; 27SELECT @@session.show_create_table_verbosity; 28@@session.show_create_table_verbosity 290 30SET SESSION show_create_table_verbosity= 1; 31SELECT @@session.show_create_table_verbosity; 32@@session.show_create_table_verbosity 331 34SET SESSION show_create_table_verbosity= 0; 35SELECT @@session.show_create_table_verbosity; 36@@session.show_create_table_verbosity 370 38#Test for DEFAULT value. 39SET SESSION show_create_table_verbosity= DEFAULT; 40SELECT @@session.show_create_table_verbosity; 41@@session.show_create_table_verbosity 420 43#Test for invalid value. 44SET SESSION show_create_table_verbosity= 2; 45ERROR 42000: Variable 'show_create_table_verbosity' can't be set to the value of '2' 46#Test for setting the session variable 47#using different syntax. 48SET show_create_table_verbosity= 1; 49#Fetches the current session value for the variable. 50SELECT @@show_create_table_verbosity; 51@@show_create_table_verbosity 521 53#cleanup 54SET SESSION show_create_table_verbosity= DEFAULT; 55#Test setting the global value of the variable. 56#Boolean values. 57SET GLOBAL show_create_table_verbosity= ON; 58SELECT @@global.show_create_table_verbosity; 59@@global.show_create_table_verbosity 601 61SET GLOBAL show_create_table_verbosity= OFF; 62SELECT @@global.show_create_table_verbosity; 63@@global.show_create_table_verbosity 640 65SET GLOBAL show_create_table_verbosity= 1; 66SELECT @@global.show_create_table_verbosity; 67@@global.show_create_table_verbosity 681 69SET GLOBAL show_create_table_verbosity= 0; 70SELECT @@session.show_create_table_verbosity; 71@@session.show_create_table_verbosity 720 73#Test for DEFAULT value. 74SET GLOBAL show_create_table_verbosity= DEFAULT; 75SELECT @@global.show_create_table_verbosity; 76@@global.show_create_table_verbosity 770 78#Test for invalid value. 79SET GLOBAL show_create_table_verbosity= 2; 80ERROR 42000: Variable 'show_create_table_verbosity' can't be set to the value of '2' 81