15.2.3 创建多表联合视图
MySQL支持在多张数据表上创建联合视图,例如,在t_goods_category数据表和t_goods数据表上创建一个名称为view_category_goods的视图。
mysql> CREATE VIEW view_category_goods
-> (category, name, price)
-> AS
-> SELECT category.t_category, goods.t_name, goods.t_price
-> FROM t_goods_category category, t_goods goods
-> WHERE category.id = goods.t_category_id;
Query OK, 0 rows affected (0.00 sec)
查看view_category_goods视图中的数据。
mysql> SELECT * FROM view_category_goods;
+-----------------+-------------+---------+
| category | name | price |
+-----------------+---------