MySQL 8.0 FAQ: Views actually executed on the replica under row-based replication. This is because, if both the source and the replica applied the changes from the source and, in addition, the trigger causing these changes were applied on the replica, the changes would in effect be applied twice on the replica, leading to different data on the source and the replica. In most cases, the outcome is the same for both row-based and statement-based replication. However, if you use different triggers on the source and replica, you cannot use row-based replication. (This is because the row-based format replicates the changes made by triggers executing on the source to the replicas, rather than the statements that caused the triggers to execute, and the corresponding triggers on the replica are not executed.) Instead, any statements causing such triggers to be executed must be replicated using statement-based replication. For more information, see Section 17.5.1.36, “Replication and Triggers” . A.6 MySQL 8.0 FAQ: Views A.6.1 Where can I find documentation covering MySQL Views? ...................................................... 5241 A.6.2 Is there a discussion forum for MySQL Views? ..................................................................... 5241 A.6.3 What happens to a view if an underlying table is dropped or renamed? .................................. 5241 A.6.4 Does MySQL 8.0 have table snapshots? .............................................................................. 5241 A.6.5 Does MySQL 8.0 have materialized views? .......................................................................... 5241 A.6.6 Can you insert into views that are based on joins? ................................................................ 5241 A.6.1. Where can I find documentation covering MySQL Views? See Section 25.5, “Using Views” . A.6.2. Is there a discussion forum for MySQL Views? Yes. See https://forums.mysql.com/list.php?100 A.6.3. What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition refers. To check a view definition for problems of this kind, use the  CHECK TABLE  statement. (See Section 13.7.3.2, “CHECK TABLE Statement” .) A.6.4. Does MySQL 8.0 have table snapshots? No. A.6.5. Does MySQL 8.0 have materialized views? No. A.6.6. Can you insert into views that are based on joins? It is possible, provided that your  INSERT  statement has a column list that makes it clear there is only one table involved. You  cannot  insert into multiple tables with a single insert on a view. A.7.1 Where can I find documentation for the MySQL  INFORMATION_SCHEMA  database? ................ 5242 A.7.2 Is there a discussion forum for  INFORMATION_SCHEMA ? ....................................................... 5242 A.7.3 Where can I find the ANSI SQL 2003 specification for  INFORMATION_SCHEMA ? ..................... 5242 A.7.4 What is the difference between the Oracle Data Dictionary and MySQL INFORMATION_SCHEMA ? .................................................................................................... 5242 A.7 MySQL 8.0 FAQ: INFORMATION_SCHEMA 5241