Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-triggers.html
(Bug #45677) A trigger can have triggers for different combinations of trigger event (INSERT, UPDATE, DELETE) and action time (BEFORE, AFTER), and multiple triggers are permitted. With statement-based replication, triggers executed on the source ...
https://dev.mysql.com/doc/refman/8.4/en/replication-implementation.html
Tables are created or their structure modified, and data is inserted, deleted, and updated according to the changes that were originally made on the source. Replication is based on the source server keeping track of all changes to its databases ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
For example: REVOKE INSERT ON *.* FROM 'jeffrey'@'localhost'; REVOKE 'role1', 'role2' FROM 'user1'@'localhost', 'user2'@'localhost'; REVOKE SELECT ON world.* FROM 'role3'; The host name part of the account or role name, if omitted, defaults to '%'.
https://dev.mysql.com/doc/refman/8.4/en/savepoint.html
(For a new inserted row, the lock information is carried by the transaction ID stored in the row; the lock is not separately stored in memory. SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/server-shutdown.html
If a thread is updating a nontransactional table, an operation such as a multiple-row UPDATE or INSERT may leave the table partially updated because the operation can terminate before completion. The server shutdown process takes place as follows: ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-trigger.html
row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE DEFINER=`me`@`localhost` TRIGGER ...
https://dev.mysql.com/doc/refman/8.4/en/signal.html
SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics (error number, SQLSTATE value, message). Without SIGNAL, it is necessary to resort ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-index-optimization.html
MySQL still maintains such indexes, as follows: They are updated for table modifications (INSERT, UPDATE, DELETE, and so forth). MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-type-overview.html
Attempts to insert values with a different SRID produce an error. MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The OpenGIS Geometry Model”. Some spatial data types ...
https://dev.mysql.com/doc/refman/8.4/en/statement-caching.html
Table content changes (for example, with INSERT or UPDATE) do not change metadata, nor do SELECT statements. For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal ...