PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/en/firewall-reference.html
ID An integer column that is a primary key for the table. ID An integer column that is a primary key for the table. When enabled, the firewall bases operational decisions on the cached data. The firewall database can be the mysql system database or ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
When inserting a big integer value (between 263 and 264−1) into a decimal or string column, it is inserted as a negative value because the number is evaluated in signed integer context. This section lists known issues in recent versions of MySQL.