SHOW Statements SHOW COLLATION  output has these columns: The collation name. The name of the character set with which the collation is associated. The collation ID. Whether the collation is the default for its character set. Whether the character set is compiled into the server. This is related to the amount of memory required to sort strings expressed in the character set. To see the default collation for each character set, use the following statement.  Default  is a reserved word, so to use it as an identifier, it must be quoted as such: Collation information is also available from the  INFORMATION_SCHEMA COLLATIONS  table. See Section 26.3.6, “The INFORMATION_SCHEMA COLLATIONS Table” . SHOW COLUMNS  displays information about the columns in a given table. It also works for views.  SHOW COLUMNS  displays information only for those columns for which you have some privilege. • Collation • Charset • Id • Default • Compiled • Sortlen mysql>  SHOW COLLATION WHERE ‘Default‘ = ’Yes’; +---------------------+----------+----+---------+----------+---------+ | Collation | Charset | Id | Default | Compiled | Sortlen | +---------------------+----------+----+---------+----------+---------+ | big5_chinese_ci | big5 | 1 | Yes | Yes | 1 | | dec8_swedish_ci | dec8 | 3 | Yes | Yes | 1 | | cp850_general_ci | cp850 | 4 | Yes | Yes | 1 | | hp8_english_ci | hp8 | 6 | Yes | Yes | 1 | | koi8r_general_ci | koi8r | 7 | Yes | Yes | 1 | | latin1_swedish_ci | latin1 | 8 | Yes | Yes | 1 | ... +-------------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------+------+-----+---------+----------------+ | ID | int(11) | NO | PRI | NULL | auto_increment | | Name | char(35) | NO | | | | | CountryCode | char(3) | NO | MUL | | | mysql>  SHOW COLUMNS FROM City; SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN}  tbl_name [{FROM | IN}  db_name ] [LIKE ’ pattern ’ | WHERE  expr ] 13.7.7.5 SHOW COLUMNS Statement 2915