create table t1 (a int, b int);
|
create algorithm=temptable view v2 (c) as select b+1 from t1;
|
show create view v2;
|
View Create View character_set_client collation_connection
|
v2 CREATE ALGORITHM=TEMPTABLE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select (`t1`.`b` + 1) AS `c` from `t1` latin1 latin1_swedish_ci
|
alter algorithm=undefined view v2 (c) as select b+1 from t1;
|
show create view v2;
|
View Create View character_set_client collation_connection
|
v2 CREATE ALGORITHM=TEMPTABLE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select (`t1`.`b` + 1) AS `c` from `t1` latin1 latin1_swedish_ci
|
alter algorithm=merge view v2 (c) as select b+1 from t1;
|
show create view v2;
|
View Create View character_set_client collation_connection
|
v2 CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select (`t1`.`b` + 1) AS `c` from `t1` latin1 latin1_swedish_ci
|
drop view v2;
|
drop table t1;
|