PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html
This example shows that VERSION() returns a string that has a case-insensitive collation, so comparisons are case-insensitive: mysql> SELECT COLLATION(VERSION()); +----------------------+ | COLLATION(VERSION()) | +----------------------+ | ... For ...
https://dev.mysql.com/doc/refman/8.0/en/create-spatial-reference-system.html
For example: mysql> CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 4326 ...; ERROR 3716 (SR005): Can't modify SRID 4326. Reserved ranges are [0, 32767] (reserved by EPSG), [60,000,000, 69,999,999] (reserved by EPSG), and [2,000,000,000, 2,147,483,647] ...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.0/en/gis-format-conversion-functions.html
MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB format, or for swapping the order of X and Y coordinates. Functions such as ST_GeomFromText() that accept WKT geometry ...
https://dev.mysql.com/doc/refman/8.0/en/gis-point-property-functions.html
mysql> SET @pt = ST_GeomFromText('POINT(45 90)', 4326); mysql> SELECT ST_Latitude(@pt); +------------------+ | ST_Latitude(@pt) | +------------------+ | 45 | +------------------+ mysql> SELECT ST_AsText(ST_Latitude(@pt, 10)); ... A Point consists of ...
https://dev.mysql.com/doc/refman/8.0/en/gis-polygon-property-functions.html
As of MySQL 8.0.13, ST_Area() handles its arguments as described in the introduction to this section, with these exceptions: If the geometry is geometrically invalid, either the result is an undefined area (that is, it can be any number), or an ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 12.14.4.2, “LDML Syntax ...The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-gr.html
From MySQL 8.0.19, as well as securing asynchronous and semi-synchronous replication, you may choose to use a PRIVILEGE_CHECKS_USER account to secure the two replication applier threads used by Group Replication. To secure one of these threads, ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-file-context.html
The MySQL Server reads from and writes to many files. The instructions that follow use the semanage binary to manage file context; on RHEL, it's part of the policycoreutils-python-utils package: yum install -y policycoreutils-python-utils After ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-file.html
(If you build NDB Cluster from source on a Unix system, the default location is /usr/local/mysql-cluster.) This can be overridden at runtime by starting the management server with the --configdir option. This file, with which you should be familiar ... Configuring NDB Cluster requires working with two files: my.cnf: Specifies options for all NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-transactions.html
NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to MySQL. Because the MySQL ... A number of limitations exist in NDB Cluster with regard to the handling of ...