mysql中的视图不太智能,稍微复杂些的视图,不能展开,下面是测试:
CREATE ALGORITHM=UNDEFINED DEFINER=`myadmin`@`` SQL SECURITY DEFINER VIEW `v_big_table` AS select `big_table`.`TABLE_CATALOG` AS `TABLE_CATALOG`,`big_table`.`TABLE_SCHEMA` AS `TABLE_SCHEMA`,`big_table`.`TABLE_NAME` AS `TABLE_NAME`,`big_table`.`COLUMN_NAME` AS `COLUMN_NAME`,`big_table`.`ORDINAL_POSITION` AS `ORDINAL_POSITION`,`big_table`.`COLUMN_DEFAULT` AS `COLUMN_DEFAULT`,`big_table`.`IS_NULLABLE` AS `IS_NULLABLE`,`big_table`.`DATA_TYPE` AS `DATA_TYPE`,`big_table