Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-spatial-reference-system.html
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 ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
In the definition of an integer column, it is an alias for NOT NULL AUTO_INCREMENT UNIQUE. Implicit defaults are defined as follows: For numeric types, the default is 0, with the exception that for integer or floating-point types declared with the ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/8.4/en/drop-spatial-reference-system.html
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. To identify which column or columns use the SRID, use this query: SELECT * ...
https://dev.mysql.com/doc/refman/8.4/en/gis-general-property-functions.html
If any SRID argument is not within the range of a 32-bit unsigned integer, an ER_DATA_OUT_OF_RANGE error occurs. ST_SRID(g [, srid]) With a single argument representing a valid geometry object g, ST_SRID() returns an integer indicating the ID of the ... The functions listed in this section do not restrict their argument and accept a geometry value of any ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-view-changes.html
The view identifier itself is built from two parts: a randomly generated part, and a monotonically increasing integer. When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to synchronize the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
For a RANGE partition, it contains the value set in the partition's VALUES LESS THAN clause, which can be either an integer or MAXVALUE. For a LIST partition, this column contains the values defined in the partition's VALUES IN clause, which is a ...
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
It was originally developed to speed up verifying the integrity of tablespace files after power outages but can also be used after file copies. Example usage: innochecksum --end-page=700 ../data/test/tab1.ibd or: innochecksum --p 700 ...This tool ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/doc/refman/8.4/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-aws-plugin.html
This is a one-time operation, performed by executing the following statements, adjusting the .so suffix for your platform as necessary: CREATE FUNCTION keyring_aws_rotate_cmk RETURNS INTEGER SONAME 'keyring_aws.so'; CREATE FUNCTION ... Note The ...