How do I create a view in MySQL?

Question

Do you have any problem with the manual? http://dev.mysql.com/doc/refman/5.0/en/create-view.html — Nicola Cossu, Mar 03 '11 at 20:08
@@nick rulez: I always trust stackoverflow for different types of suggestions and answers. that's y i posted here. — Fero, Mar 05 '11 at 06:48
Thanks for the compliment. However, we'd rather you try to figure it out first. — mellamokb, Mar 05 '11 at 13:01
@@mella: Thanks for your advice mella. Hereafter i will do the same and if i didn't get my exact answer i will come here... :-) — Fero, Mar 07 '11 at 04:40
mellamokb its better to just get simple answers from all these stack overflow experts than hunt for answers from all over the web. — webs, Jan 03 '18 at 16:18

score 56 · Accepted Answer · answered Mar 03 '11 at 20:09

56

Example:

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

answered Mar 03 '11 at 20:09

mellamokb

score 8 · Answer 2 · answered Mar 03 '11 at 20:09

8

CREATE VIEW v AS SELECT * FROM t;

answered Mar 03 '11 at 20:09

John K.

2 Answers2