0

can anyone explain what is view what is the function of view what is the syntax? As I am a beginner so if you give me the actual definition of it, it will be very useful to gather knowledge or to understand what is VIEW

22nd Aug 2016, 8:56 PM
Dipayan Pramanik
Dipayan Pramanik - avatar
4 Antworten
+ 3
A View is like a stored SELECT statement. It stores no data, and only returns data when you run a SELECT against it. Think of a View as a way to simplify a complex SQL query; you can reference a View in a SQL statement and treat it like a Table. To create: CREATE VIEW my_view AS SELECT column_name1, column_name2 ... FROM table1; To use: SELECT column_name1 FROM my_view; A View can contain complex SQL; as it creates a "virtual" table, you can join to it to save having to write the complex SQL multiple times.
22nd Aug 2016, 10:32 PM
Michael Skae
Michael Skae - avatar
+ 1
view displays a data from the virtual table
23rd Aug 2016, 6:35 AM
Rohit Meshram
Rohit Meshram - avatar
- 1
the arrangement of words and phrases to create well-formed sentences in a language. "the syntax of English" a set of rules for or an analysis of this. plural noun: syntaxes "generative syntax" the branch of linguistics that deals with this
3rd Oct 2016, 8:57 PM
Owais Ahmed
Owais Ahmed - avatar
- 1
:)
26th Mar 2017, 6:43 PM
Artur Denisenko
Artur Denisenko - avatar