为了说明如何使用 inner join 制作 mysql 视图，我们使用“customers”和“resreve”表中的以下数据 -
mysql> select * from customers;+-------------+----------+| customer_id | name |+-------------+----------+| 1 | rahul || 2 | yashpal || 3 | gaurav || 4 | virender |+-------------+----------+4 rows in set (0.00 sec)mysql> select * from reserve;+------+------------+| id | day |+------+------------+| 1 | 2017-12-30 || 2 | 2017-12-28 || 2 | 2017-12-25 || 1 | 2017-12-24 || 3 | 2017-12-26 |+------+------------+5 rows in set (0.00 sec)
现在，以下查询将在上述表上使用 inner join 创建一个名为“customer_v”的视图，该视图将包含预订一辆或多辆汽车的客户的姓名。
mysql> create view customer_v as select distinct name from customers c inner join reserve r on r.id = c.customer_id;query ok, 0 rows affected (0.08 sec)mysql> select * from customer_v;+---------+| name |+---------+| rahul || yashpal || gaurav |+---------+3 rows in set (0.02 sec)
以上就是我们如何使用 inner join 创建 mysql 视图？的详细内容。