在mysql查询中查看 [英] view in mysql queries

问题描述

我们可以创建如下查询的视图



创建视图vChitta;



为什么我们选择语句reference

can we create view like following query

create view vChitta ;

Why wegive select statement reference

推荐答案

在创建视图时，您需要通过SELECT语句指定详细信息，无需SELECT语句你不能创建视图。

Hi,

While Creating view you need to specify the Details through SELECT Statement,Without SELECT Statement you can''t Create VIEW.

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

在View Creation中，select_statement是必需的。所以SELECT声明是必须的。



阅读以下VIEW视图链接。



创建视图语法 [ ^ ]



SQL视图 [ ^ ]



查看 [ ^ ]



不同类型的SQL Server视图 [ ^ ]



问候，

GVPrabu

In View Creation select_statement is mandatory. So "SELECT" Statement is Must.

Read the following links for VIEWs.

CREATE VIEW Syntax[^]

SQL Views[^]

Views[^]

Different Types of SQL Server Views[^]

Regards,
GVPrabu

这篇关于在mysql查询中查看的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！