MySql 中的自动视图更新

问题描述

当底层表在 MySQL 中更新而不查询时，视图是否会自动更新?

Does the view get automatically updated when the underlying tables get updated in MySQL without querying?

进一步说明 - 如果我更新表，那么即使我没有在视图上运行任何查询，视图也会更新吗?

To further elaborate - if I update the table then does the view get updated even if I don't run any query on the view?

推荐答案

每次在视图上执行查询时，它都会获取当前在表中的数据 - 包括所有已提交的事务，但不包括那些 UPDATE 或 INSERT 查询尚未提交.

Every time you execute a query on the view, it will fetch the data currently in tables - included all committed transactions on it, but not those UPDATE or INSERT queries taht have still not been committed.

当然，一旦你得到了那个数据，它就不会再发送了.有触发器，但您的数据库客户端仍然必须查询视图数据.

but of course, once you have got that data, it will not send it again. There are triggers for that, but still your database client has to query the view data out.

再澄清一点:视图不存储(缓存)数据，它是一个逻辑结构，将始终查看底层表.

To clear up a bit more: View does not store (cache) the data, it is a logical structure and will always look into the underlying tables.

这篇关于MySql 中的自动视图更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！