How do I create a view in MySQL? [closed]

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

---

Want to improve this question? Update the question so it focuses on one problem only by editing this post.

Closed 8 years ago.

开发者_如何学Python Improve this question

How do I create a view in MySQL?

---

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

Example:

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

---

CREATE VIEW v AS SELECT * FROM t;