MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 171 to 180 of 186 total results

https://dev.mysql.com/doc/refman/9.7/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 ...

15.7.7.41 SHOW TRIGGERS Statement

https://dev.mysql.com/doc/refman/9.7/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, ...

27.3.3 JavaScript Stored Program Language Support

https://dev.mysql.com/doc/refman/9.7/en/srjs-language-support.html

This implementation includes all of the standard ECMAScript library objects such as Object, Function, Math, Date, String, and so forth. JavaScript language support in MySQL conforms to the ECMAScript 2024 Specification, and uses strict mode by ...

27.3.8 Using JavaScript Libraries

https://dev.mysql.com/doc/refman/9.7/en/srjs-libraries.html

row *************************** LIBRARY_CATALOG: def LIBRARY_SCHEMA: jslib LIBRARY_NAME: lib1 LIBRARY_DEFINITION: export function f(n) { return n } LANGUAGE: JAVASCRIPT CREATED: 2024-12-16 09:20:26 LAST_ALTERED: 2024-12-16 09:20:26 SQL_MODE: ...

27.3.6.1 Session Object

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-session.html

(This does not affect the result of toLocaleString() or NumberFormat called with an explicit locale.) If lc_time_names is updated, call mle_session_reset() to cause any existing stored programs to use the new locale setting by default instead. The ...

27.10 Restrictions on Stored Programs

https://dev.mysql.com/doc/refman/9.7/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 ...

27.9 Stored Program Binary Logging

https://dev.mysql.com/doc/refman/9.7/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 ...

10.4.6 Limits on Table Size

https://dev.mysql.com/doc/refman/9.7/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, ...

13.2.3 The TIME Type

https://dev.mysql.com/doc/refman/9.7/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), ...

10.3.14 Indexed Lookups from TIMESTAMP Columns

https://dev.mysql.com/doc/refman/9.7/en/timestamp-lookups.html

Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. (This is the same type of conversion performed by the CONVERT_TZ() ...

Displaying 171 to 180 of 186 total results