• CREATE VIEW
    • 语法图
    • 示例
    • MySQL 兼容性
    • 另请参阅

    CREATE VIEW

    使用 CREATE VIEW 语句将 SELECT 语句保存为类似于表的可查询对象。TiDB 中的视图是非物化的，这意味着在查询视图时，TiDB 将在内部重写查询，以将视图定义与 SQL 查询结合起来。

    语法图

    CreateViewStmt:

    CreateViewStmt

    OrReplace:

    OrReplace

    ViewAlgorithm:

    ViewAlgorithm

    ViewDefiner:

    ViewDefiner

    ViewSQLSecurity:

    ViewSQLSecurity

    ViewName:

    ViewName

    ViewFieldList:

    ViewFieldList

    ViewCheckOption:

    ViewCheckOption

    示例

    1. mysql> CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY auto_increment, c1 INT NOT NULL);
    2. Query OK, 0 rows affected (0.11 sec)
    4. mysql> INSERT INTO t1 (c1) VALUES (1),(2),(3),(4),(5);
    5. Query OK, 5 rows affected (0.03 sec)
    6. Records: 5  Duplicates: 0  Warnings: 0
    8. mysql> CREATE VIEW v1 AS SELECT * FROM t1 WHERE c1 > 2;
    9. Query OK, 0 rows affected (0.11 sec)
    11. mysql> SELECT * FROM t1;
    12. +----+----+
    13. | id | c1 |
    14. +----+----+
    15. |  1 |  1 |
    16. |  2 |  2 |
    17. |  3 |  3 |
    18. |  4 |  4 |
    19. |  5 |  5 |
    20. +----+----+
    21. 5 rows in set (0.00 sec)
    23. mysql> SELECT * FROM v1;
    24. +----+----+
    25. | id | c1 |
    26. +----+----+
    27. |  3 |  3 |
    28. |  4 |  4 |
    29. |  5 |  5 |
    30. +----+----+
    31. 3 rows in set (0.00 sec)
    33. mysql> INSERT INTO t1 (c1) VALUES (6);
    34. Query OK, 1 row affected (0.01 sec)
    36. mysql> SELECT * FROM v1;
    37. +----+----+
    38. | id | c1 |
    39. +----+----+
    40. |  3 |  3 |
    41. |  4 |  4 |
    42. |  5 |  5 |
    43. |  6 |  6 |
    44. +----+----+
    45. 4 rows in set (0.00 sec)
    47. mysql> INSERT INTO v1 (c1) VALUES (7);
    48. ERROR 1105 (HY000): insert into view v1 is not supported now.

    MySQL 兼容性

    • 目前 TiDB 中的视图不可插入且不可更新。

    另请参阅

    • CREATE TABLE
    • SHOW CREATE TABLE
    • DROP TABLE