Live View 视图简介

  • 类似时间监听器
  • 需设置 allow_experimental_live_view 为 1,检查

    1
    
    SELECT name, value FROM system.settings WHERE name LIKE '%live_view%';

创建 Live View 视图

  • 创建

    1
    
    CREATE LIVE VIEW lv_name AS SELECT count(*) FROM table_name;
  • 监听

    1
    
    WATCH lv_name