本文探讨了在MySQL中使用视图时遇到的数据不实时更新的问题，特别是视图数据刷新存在的延迟现象。通过深入分析SQL查询语句，展示了一个包含多个JOIN操作和条件过滤的复杂视图实例，并提出了解决视图数据延迟更新的可能方法。
select h.*,i.staff_name person_name from (SELECT
a.ec_id AS ec_id,
a.region_id AS region_id,
e.region_name AS region_name,
a.production_process_id as production_process_id,
a.production_process_name as production_process_name,
a.production_process_type as production_process_type,
g.entry_name as production_process_type_name,
a.entity_id AS entity_id,
a.create_time as create_time,
a.create_id as create_id,
a.status as status,
max(IF ((d.tag = 'BeginTime'),b.attr_value,NULL)) AS begin_time,
max(IF ((d.tag = 'EndTime'),b.attr_value,NULL)) AS end_time,
max(IF ((d.tag = 'Person'),b.attr_value,NULL)) AS person,
max(IF ((d.tag = 'Event'),b.attr_value,NULL)) AS event
FROM erp_production_process a
LEFT JOIN (select * from entity_attr_value where inure_time <&#
最低0.47元/天 解锁文章
759
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
