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