SHOW Statements The default character set mapping can be restored by using the value  DEFAULT . The default depends on the server configuration. Some character sets cannot be used as the client character set. Attempting to use them with  SET CHARACTER SET  produces an error. See Impermissible Client Character Sets. 13.7.6.3 SET NAMES Statement SET NAMES {’ charset_name ’ [COLLATE ’ collation_name ’] | DEFAULT} This statement sets the three session system variables  character_set_client , character_set_connection , and  character_set_results  to the given character set. Setting character_set_connection  to  charset_name  also sets  collation_connection  to the default collation for  charset_name . See Section 10.4, “Connection Character Sets and Collations” . The optional  COLLATE  clause may be used to specify a collation explicitly. If given, the collation must one of the permitted collations for  charset_name . charset_name  and  collation_name  may be quoted or unquoted. The default mapping can be restored by using a value of  DEFAULT . The default depends on the server configuration. Some character sets cannot be used as the client character set. Attempting to use them with  SET NAMES produces an error. See Impermissible Client Character Sets. SHOW  has many forms that provide information about databases, tables, columns, or status information about the server. This section describes those following: SHOW {BINARY | MASTER} LOGS SHOW BINLOG EVENTS [IN ’ log_name ’] [FROM  pos ] [LIMIT [ offset ,]  row_count ] SHOW CHARACTER SET [ like_or_where ] SHOW COLLATION [ like_or_where ] SHOW [FULL] COLUMNS FROM  tbl_name  [FROM  db_name ] [ like_or_where ] SHOW CREATE DATABASE  db_name SHOW CREATE EVENT  event_name SHOW CREATE FUNCTION  func_name SHOW CREATE PROCEDURE  proc_name SHOW CREATE TABLE  tbl_name SHOW CREATE TRIGGER  trigger_name SHOW CREATE VIEW  view_name SHOW DATABASES [ like_or_where ] SHOW ENGINE  engine_name  {STATUS | MUTEX} SHOW [STORAGE] ENGINES SHOW ERRORS [LIMIT [ offset ,]  row_count ] SHOW EVENTS SHOW FUNCTION CODE  func_name SHOW FUNCTION STATUS [ like_or_where ] SHOW GRANTS FOR  user SHOW INDEX FROM  tbl_name  [FROM  db_name ] SHOW MASTER STATUS SHOW OPEN TABLES [FROM  db_name ] [ like_or_where ] SHOW PLUGINS SHOW PROCEDURE CODE  proc_name SHOW PROCEDURE STATUS [ like_or_where ] SHOW PRIVILEGES SHOW [FULL] PROCESSLIST SHOW PROFILE [ types ] [FOR QUERY  n ] [OFFSET  n ] [LIMIT  n ] 2911 13.7.7 SHOW Statements