CREATE materialized VIEW VIEW_TEST refresh FORCE ON demand START WITH SYSDATE next TRUNC ( SYSDATE + 29 )+ 5.5 / 24 AS
SELECT
*
FROM
mes_lot
下面可以运行,但是我想让他每月刷新一下
CREATE VIEW VIEW_TEST
AS SELECT
老哥们好像MySQL不支持物化视图
可以参考这个链接:https://www.alibabacloud.com/help/zh/analyticdb-for-mysql/latest/refresh-materialized-views