mysql查询视图_如何查看 mysql 的视图？

1、查询表(包括view)

mysql> use iips;

Database changed

mysql> show tables;

+----------------------------+

| Tables_in_iips |

+----------------------------+

| tbepartner |

| tbepartnerconfig |

| tborg |

+----------------------------+

3 rows in set

2、查询视图

mysql> show table status where comment ='view';

+-------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+---------+

| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |

+-------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+---------+

| tborg | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW |

+-------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+---------+

1 row in set