mysql8.0支持物化视图，我在8.3.0版本，创建物化视图，提示语法错误是怎么回事呢？
create MATERIALIZED view mv_t as
select id,name,email from t
提示报错：
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'materialized view mv_t as
select id,name,email from t' at line 1
已经确定，执行如下语句是正常的：
select id,name,email from t
select version();
+-----------+
| version() |
+-----------+
| 8.0.32-25 |
+-----------+
1 row in set (0.01 sec)
mysql> help create
Many help items for your request exist.
To make a more specific request, please type 'help <item>',
where <item> is one of the following
topics:
CREATE DATABASE
CREATE EVENT
CREATE FUNCTION
CREATE FUNCTION LOADABLE FUNCTION
CREATE INDEX
CREATE LOGFILE GROUP
CREATE PROCEDURE
CREATE RESOURCE GROUP
CREATE ROLE
CREATE SCHEMA
CREATE SERVER
CREATE SPATIAL REFERENCE SYSTEM
CREATE TABLE
CREATE TABLESPACE
CREATE TRIGGER
CREATE USER
CREATE VIEW
SHOW
SHOW CREATE DATABASE
SHOW CREATE EVENT
SHOW CREATE FUNCTION
SHOW CREATE PROCEDURE
SHOW CREATE SCHEMA
SHOW CREATE TABLE
SHOW CREATE USER
SPATIAL INDEXES
我没发现创建物化视图的语句。
评论
有用 1
墨值悬赏