PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/gis-data-formats.html
For example, both of the following function calls are valid, whereas before MySQL 5.7.9 the second one produces an error: ST_MPointFromText('MULTIPOINT (1 1, 2 2, 3 3)') ST_MPointFromText('MULTIPOINT ((1 1), (2 2), (3 3))') As of MySQL 5.7.9, output ...The second uses a WKT representation converted to a Point with ... Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry ...
https://dev.mysql.com/doc/refman/5.7/en/bit-functions.html
(The BIT_AND(), BIT_OR(), and BIT_XOR() functions are aggregate functions described at Section 12.19.1, “Aggregate Function Descriptions”.) Currently, bit functions and operators require BIGINT (64-bit integer) arguments and return BIGINT ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-exclusive-to-cluster.html
Setting NoOfReplicas to a value greater than 2 is possible (to a maximum of 4) but unnecessary to guard against loss of data. The following are limitations specific to the NDB storage engine: Machine architecture. All machines used in the cluster ...
https://dev.mysql.com/doc/refman/5.7/en/automatic-start.html
systemd, the mysqld_safe and mysql.server scripts, Solaris SMF, and the macOS Startup Item (or MySQL Preference Pane) can be used to start the server manually, or automatically at system startup time. This section discusses methods for starting and ...
https://dev.mysql.com/doc/refman/5.7/en/backup-and-recovery.html
If the primary fails, a secondary is automatically promoted to the role of primary, and MySQL Router routes requests to the new primary. It is important to back up your databases so that you can recover your data and be up and running again in case ...
https://dev.mysql.com/doc/refman/5.7/en/changing-mysql-user.html
To start the server as the given user automatically at system startup time, specify the user name by adding a user option to the [mysqld] group of the /etc/my.cnf option file or the my.cnf option file in the server's data directory. On Windows, you ...
https://dev.mysql.com/doc/refman/5.7/en/charset-examples.html
Example 2: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 ) DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci; This time we have a column with a latin1 character set and a default collation. The following ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
MATCH options do not have any other effect in MySQL, which in effect enforces MATCH SIMPLE semantics full-time. Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent.
https://dev.mysql.com/doc/refman/5.7/en/faqs-migration.html
This may seem more complicated, but ultimately saves time and trouble. Where can I find information on how to upgrade or downgrade MySQL? A.8.2. How has storage engine (table type) support changed in MySQL 5.7 from previous versions? A.8.1. Where ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-security.html
Does MySQL include support for Roles Based Access Control (RBAC)? Not at this time. Where can I find documentation that addresses security issues for MySQL? A.9.2. Is SSL support built into MySQL binaries, or must I recompile the binary myself to ...