我们如何使用子查询创建 MySQL 视图？

为了说明如何使用子查询创建 MySQL 视图，我们使用“Cars”表中的以下数据 -

mysql> select * from cars; +------+--------------+---------+ | ID   | Name         | Price   | +------+--------------+---------+ |    1 | Nexa         | 750000  | |    2 | Maruti Swift | 450000  | |    3 | BMW          | 4450000 | |    4 | VOLVO        | 2250000 | |    5 | Alto         | 250000  | |    6 | Skoda        | 1250000 | |    7 | Toyota       | 2400000 | |    8 | Ford         | 1100000 | +------+--------------+---------+ 8 rows in set (0.08 sec)登录后复制

mysql> Create view cars_avgprice AS SELECT NAME, Price FROM Cars WHERE price > (SELECT AVG(Price) from cars); Query OK, 0 rows affected (0.12 sec) mysql> Select * from cars_avgprice; +--------+---------+ | NAME   | Price   | +--------+---------+ | BMW    | 4450000 | | VOLVO  | 2250000 | | Toyota | 2400000 | +--------+---------+ 3 rows in set (0.03 sec)登录后复制

mysql> Select AVG(Price) from cars; +--------------+ | AVG(Price)   | +--------------+ | 1612500.0000 | +--------------+ 1 row in set (0.00 sec)登录后复制

以上就是我们如何使用子查询创建 MySQL 视图？的详细内容，更多请关注每日运维网(www.mryunwei.com)其它相关文章！