格式为:CREATE VIEW AS <SELECT语句>,如:

CREATE VIEW myview AS select * from mytab;