1. -- 查看当前数据库中的表
    2. SHOW table_name;
    5. -- 查看表结构
    6. show columns from 表名;
    1. -- 不切换数据库，显示特定数据库中的表
    2. SHOW TABLE STATUS [FROM db_name] [like_or_where]
    4. show tables from dkf;
    5. +---------------+
    6. | Tables_in_dkf |
    7. +---------------+
    8. | dkf_test      |
    9. | dkftab        |
    10. | my_test       |
    11. +---------------+
    13. 3 rows in set (0.00 sec)
    1. -- 显示表中列名称
    2. show column from table_name;
    4. show columns from dkftab;
    5. +-------+-------------+------+-----+---------+-------+
    6. | Field | Type        | Null | Key | Default | Extra |
    7. +-------+-------------+------+-----+---------+-------+
    8. | name  | varchar(10) | YES  |     | NULL    |       |
    9. +-------+-------------+------+-----+---------+-------+
    10. 1 row in set (0.00 sec)
    13. show columns from database_name.table_name;
    15. show columns from dkf.dkftab;
    16. +-------+-------------+------+-----+---------+-------+
    17. | Field | Type        | Null | Key | Default | Extra |
    18. +-------+-------------+------+-----+---------+-------+
    19. | name  | varchar(10) | YES  |     | NULL    |       |
    20. +-------+-------------+------+-----+---------+-------+
    21. 1 row in set (0.00 sec)
    24. show columns from table_name from database_name;
    26. show columns from dkftab from dkf;
    27. +-------+-------------+------+-----+---------+-------+
    28. | Field | Type        | Null | Key | Default | Extra |
    29. +-------+-------------+------+-----+---------+-------+
    30. | name  | varchar(10) | YES  |     | NULL    |       |
    31. +-------+-------------+------+-----+---------+-------+
    32. 1 row in set (0.00 sec)
    1. -- 显示表的索引
    2. show index from table_name;
    4. show index from dkf.dkftab;
    5. +--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    6. | Table  | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
    7. +--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    8. | dkftab |          1 | idx_name |            1 | name        | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
    9. +--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    10. 1 row in set (0.00 sec)
    13. show create table table_name;
    15. show create table dkf.dkftab\G
    16. *************************** 1. row ***************************
    17.        Table: dkftab
    18. Create Table: CREATE TABLE `dkftab` (
    19.   `name` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    20.   KEY `idx_name` (`name`)
    21. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    22. 1 row in set (0.00 sec)