为了说明如何使用 right 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)
现在，以下查询将使用上述表上的 right join 创建一个名为“customer_vright”的视图，其中包含尚未预订任何汽车的客户的姓名。
mysql> create view customer_vright as select name from reserve right join customers on customer_id = id where id is null;query ok, 0 rows affected (0.08 sec)mysql> select * from customer_vright;+----------+| name |+----------+| virender |+----------+1 row in set (0.00 sec)
以上就是我们如何使用 right join 创建 mysql 视图？的详细内容。