mysql> select table_name from information_schema.`tables` where table_type like'view' and table_schema like 'query';+-----------------------------+| table_name |+-----------------------------+| customer_view || first_view || info || info_less || view_detail || view_student_detail || view_student_detail_columns |+-----------------------------+7 rows in set (0.01 sec)mysql> show full tables in query where table_type like 'view';+-----------------------------+------------+| tables_in_query | table_type |+-----------------------------+------------+| customer_view | view || first_view | view || info | view || info_less | view || view_detail | view || view_student_detail | view || view_student_detail_columns | view |+-----------------------------+------------+7 rows in set (0.01 sec)mysql> select table_schema, table_name -> from information_schema.tables -> where table_type like 'view'and table_schema = 'query';+--------------+-----------------------------+| table_schema | table_name |+--------------+-----------------------------+| query | customer_view || query | first_view || query | info || query | info_less || query | view_detail || query | view_student_detail || query | view_student_detail_columns |+--------------+-----------------------------+7 rows in set (0.05 sec)
以上就是我们如何查看存储在特定 mysql 数据库中的视图列表？的详细内容。