Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-loadable-functions.html
See Section 7.6.4, “The Rewriter Query Rewrite Plugin” Version Tokens enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. MySQL supports loadable functions, ...
https://dev.mysql.com/doc/refman/8.4/en/server-plugins.html
Version Tokens enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. MySQL supports an plugin API that enables creation of server plugins. Plugins can be loaded at ...
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/show-procedure-status.html
It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL extension. A ...
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
However, because the file positions are not being regularly updated in the connection metadata repository and the applier metadata repository except in a few situations, they are likely to be out of date if the server is restarted. When the receiver ... SHOW REPLICA STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/8.4/en/show-triggers.html
row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
If a trigger uses a table and the table has changed since the trigger was loaded into the cache, the trigger operates using the outdated metadata. Consequently, stored functions that update the same underlying tables do not execute in parallel. Some ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
These events bring databases up to date from the point of the backup. Triggers can update tables, so error messages similar to those for stored functions occur with CREATE TRIGGER if you do not have the required privileges. If a function that ...
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
For up-to-date information operating system file size limits, refer to the documentation specific to your operating system. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, ...
https://dev.mysql.com/doc/refman/8.4/en/time.html
MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large because the TIME type can be used not only to represent a time of day (which must be less than 24 hours), ...