一、创建视图 CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION] 1. 2. 3. 4. 1)OR REPLACE:表示替换已有视图 2)ALGORITH