2021年9月2日
Mysql 导出视图、触发器
摘要： 一：导出视图 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 唏嘘- 阅读(906) 评论(0) 推荐(0)
Mysql 视图
摘要： 一、创建视图： CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] 阅读全文
posted @ 2021-09-02 15:17 唏嘘- 阅读(80) 评论(0) 推荐(0)