范式：
CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
VIEW view_name [(column_list)]
AS select_statement
[WITH [CASCADED | LOCAL] CHECK OPTION]
实例：
CREATE ALGORITHM=TEMPTABLE
VIEW `ie_processed_domain_counter`
AS select count(0) AS `count(*)` from `domain_log` where (`domain_log`.`processed1` = 1);
更多介绍参见此处。
0
