使用视图 === ## 知识点 ``` create view ... 创建视图 drop view ... 删除视图 ``` ## 实战 ``` > select u.player,t.content from users as u,twitters as t where u.id - t.user_id and u.id = 1 > create view curray_twitters as (sql语句) // 创建视图 > select * from curry_twitters; > drop view curry_twitters; // 删除视图 ```