MYSQL 视图操作

创建视图

<pre name="code" class="sql">CREATE ALGORITHM = MERGE VIEW <span style="font-family: Arial, Helvetica, sans-serif;">视图名称</span>(id,name,sex,address,salery)AS SELECT `user`.id,`user`.`name`,`user`.sex,`user`.address,gz.salery FROM `user`,gzWHERE `user`.id=gz.userid

</pre>删除视图<pre>

<pre name="code" class="sql">drop view if exists 视图名称