如何在 MySQL 中创建视图？

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

---

想要改进这个问题吗？通过编辑这篇文章来更新问题，使其仅关注一个问题。

10 年前已关闭。

Answer 1

http://dev.mysql.com/doc/refman/5.5 /en/create-view.html

示例：

Create View `MyViewName` as 
    Select
        col1, col2, col3
    From
        myTable T

Answer 2

CREATE VIEW v AS SELECT * FROM t;