mysql视图数据更新_mysql 视图的数据刷新存在延迟

问题描述

请问一下各位大佬，我在一个请求中更新了一个mysql表的数据，请求结束以后立马在另一个请求中查询包含这个表的视图，会查到修改之前的旧数据，在请求一次才能查到新的数据了，而且不是每次都会出现这种情况。

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 = &#