聘我网

新概念招聘3.0

MySQL中如何建立视图(View)?

vote up0vote downstar

能否提供个简单的例子,官网的太废话式了

 

1 个答复

vote up0vote downcheck

范式:

CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
VIEW view_name [(column_list)]
AS select_statement
[WITH [CASCADED | LOCAL] CHECK OPTION]

实例:

CREATE ALGORITHM=TEMPTABLE 
VIEW `ie_processed_domain_counter` 
AS select count(0) AS `count(*)` from `domain_log` where (`domain_log`.`processed1` = 1);

更多介绍参见此处

链接

您的回答





不是您要找的问题? 浏览其他含有标签 的问题或者 自己问个.