you are at Encyclopedia of SQL >> CREATE VIEW
CREATE VIEW
CREATE VIEW creates virtual tables which can be result os SQL query. We can use
such tables as physical tables.
Syntax for creatin new view
CREATE VIEW view_name AS
SELECT `column_name1` [,`column_name2`,...]
FROM `table_name1` [,`table_name2`,...]
[WHERE condition]
Syntax for deleting of existing view
DROP VIEW view_name
Example
Stwórz widok, który będzie połączeniem tabel osoby i wiek
| id | name | surname |
|---|
| 1 | Paweł | Kowalski |
| 2 | Piotr | Janik |
| 3 | Paweł | Kowalski |
query
CREATE VIEW `peopleANDage`
AS SELECT `id`,`name`,`surname`,`age` WHERE `id`=`person_id`
result
| id | name | surname | age |
|---|
| 1 | Paweł | Kowalski | 3 |
| 2 | Piotr | Janik | 7 |
| 3 | Paweł | Kowalski | 13 |
[ wróć na górę strony ]
