Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-dynamic-cursor.html
You can enable this function within Windows by selecting the Enable Dynamic Cursor check box within the ODBC Data Source Administrator. Support for the dynamic cursor is provided in Connector/ODBC 3.51, but dynamic cursors are not enabled by ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-last-insert-id.html
To obtain the value immediately after an INSERT, use a SELECT query with the LAST_INSERT_ID() function. Obtaining the value of column that uses AUTO_INCREMENT after an INSERT statement can be achieved in a number of different ways. For example, ...
https://dev.mysql.com/doc/refman/8.4/en/sys-extract-table-from-file-name.html
This function is useful when extracting file I/O information from the Performance Schema that includes file path names. Given a file path name, returns the path component that represents the table name. It provides a convenient way to display table ...
https://dev.mysql.com/doc/refman/8.4/en/sys-list-add.html
This function and list_drop() can be useful for manipulating the value of system variables such as sql_mode and optimizer_switch that take a comma-separated list of values. Adds a value to a comma-separated list of values and returns the result.
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-consumer-enabled.html
This function accounts for the consumer hierarchy, so a consumer is not considered enabled unless all consumers on which depends are also enabled. Returns YES or NO to indicate whether a given Performance Schema consumer is enabled, or NULL if the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-version-major.html
This function returns the major version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_major(); +-----------+---------------------+ | VERSION() | sys.version_major() | +-----------+---------------------+ | 8.4.2 | 8 | ...
https://dev.mysql.com/doc/refman/8.4/en/sys-version-minor.html
This function returns the minor version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_minor(); +-----------+---------------------+ | VERSION() | sys.version_minor() | +-----------+---------------------+ | 8.4.2 | 4 | ...
https://dev.mysql.com/doc/refman/8.4/en/sys-version-patch.html
This function returns the patch release version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_patch(); +-----------+---------------------+ | VERSION() | sys.version_patch() | +-----------+---------------------+ | 8.4.2 | 2 | ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-named-windows.html
Windows can be defined and given names by which to refer to them in OVER clauses. If present in a query, the WINDOW clause falls between the positions of the HAVING and ORDER BY clauses, and has this syntax: WINDOW window_name AS (window_spec) [, ...