Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-spatial-reference-system.html
The resulting data dictionary entry can be inspected using the INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS table. With CREATE OR REPLACE syntax, any existing SRS definition with the same SRID value is replaced, unless the SRID value is used by ...srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and stores it in the data ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-reference.html
Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data. The tables can be accessed only by users who have privileges for that database. If these tables are missing, the ...Unless those objects are installed, the audit_log plugin operates in (deprecated) legacy ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-reference-api.html
The following tables list Connector/ODBC API calls grouped by task: Table 5.5 ODBC API Calls for Connecting to a Data Source Function Name Connector/ODBC Supports? Standard Purpose SQLAllocHandle Yes ISO 92 Obtains an environment, connection, ...For ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-api.html
The following tables list Connector/ODBC API calls grouped by task: Table 7.1 ODBC API Calls for Connecting to a Data Source Function Name Connector/ODBC Supports? Standard Purpose SQLAllocHandle Yes ISO 92 Obtains an environment, connection, ...For ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
gtid_executed_compression_period: Compress gtid_executed table each time this many transactions have occurred. Replica_open_temp_tables: Number of temporary tables that replication SQL thread currently has open. replicate-do-table: Tells replication ... The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-reference-systems.html
MySQL maintains information about available spatial reference systems for spatial data in the data dictionary mysql.st_spatial_reference_systems table, which can store entries for projected and geographic SRSs. This data dictionary table is ... A ...
https://dev.mysql.com/doc/refman/8.4/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...If ...
https://dev.mysql.com/doc/refman/8.4/en/drop-spatial-reference-system.html
If the SRID value is used by some column in an existing table, an error occurs. DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement removes a spatial reference system (SRS) definition from the data dictionary. Example: DROP SPATIAL REFERENCE SYSTEM 4120; If no SRS definition with the SRID value exists, an error occurs unless IF EXISTS is ...
https://dev.mysql.com/doc/refman/8.4/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...