摘要: 一:导出视图 SELECT CONCAT("DROP VIEW IF EXISTS `",TABLE_SCHEMA,"`.`",TABLE_NAME,"`;\nCREATE VIEW `", TABLE_SCHEMA,"`.`",TABLE_NAME,"` as ",VIEW_DEFINITION, 阅读全文
posted @ 2021-09-02 17:35 唏嘘- 阅读(868) 评论(0) 推荐(0) 编辑
摘要: 一、创建视图: CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] 阅读全文
posted @ 2021-09-02 15:17 唏嘘- 阅读(67) 评论(0) 推荐(0) 编辑