CREATE
[ALGORITHM = {
MERGE | TEMPTABLE | UNDEFINED}]
VIEW [database_name].[view_name]
AS
[SELECT statement]
创建视图语句 create view 可选项 ALGORITHM 子句表示视图处理算法
共三个参数: MERGE | TEMP
CREATE
[ALGORITHM = {
MERGE | TEMPTABLE | UNDEFINED}]
VIEW [database_name].[view_name]
AS
[SELECT statement]
创建视图语句 create view 可选项 ALGORITHM 子句表示视图处理算法
共三个参数: MERGE | TEMP