PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/spatial-operator-functions.html
The function is implemented for LineString geometries in all spatial reference systems, both Cartesian and geographic. The function is implemented for LineString geometries in all spatial reference systems, both Cartesian and geographic. The ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-relation-functions-mbr.html
The MBR (also known as the bounding box) for a two-dimensional geometry is the smallest rectangle which holds all points in the geometry, and so encloses the area between its greatest extents in both coordinate directions. In this case, ... MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/sql-mode.html
When this manual refers to “strict mode,” it means a mode with either or both STRICT_TRANS_TABLES or STRICT_ALL_TABLES enabled. SELECT DELETE (both single table and multiple table) INSERT LOAD DATA LOAD XML SELECT SLEEP() UPDATE (both single ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-llm.html
Both versions of these methods support variants of the methods for performing single jobs and batch processing. It supports two variants, one for a single invocation, and one for batch processing; both of these are described in the next few ... LLM ...
https://dev.mysql.com/doc/refman/9.7/en/start-replica.html
For the thread type options, you can specify IO_THREAD, SQL_THREAD, both of these, or neither of them. START REPLICA with no thread type options starts all of the replication threads, and so does START REPLICA with both of the thread type options. A ... START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ...
https://dev.mysql.com/doc/refman/9.7/en/string-functions.html
TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str), TRIM([remstr FROM] str) Returns the string str with all remstr prefixes or suffixes removed. If none of the specifiers BOTH, LEADING, or TRAILING is given, BOTH is assumed. mysql> SELECT TRIM(' ...For functions that operate on string positions, the first position is numbered ...
https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html
The following rules describe how conversion occurs for comparison operations: If one or both arguments are NULL, the result of the comparison is NULL, except for the NULL-safe <=> equality comparison operator. If both arguments in a comparison ...
https://dev.mysql.com/doc/refman/9.7/en/alter-table-partition-operations.html
Both options take a comma-separated list of one or more partition names. TABLESPACE on subpartitioned tables, both partition and subpartition names are allowed. Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for ...
https://dev.mysql.com/doc/refman/9.7/en/binary-log-transaction-compression.html
Binary log transaction compression therefore saves storage space both on the originator of the transaction and on the recipient (and for their backups), and saves network bandwidth when the transactions are sent between server instances. Setting ...
https://dev.mysql.com/doc/refman/9.7/en/command-line-options.html
The MySQL server has certain command options that may be specified only at startup, and a set of system variables, some of which may be set at startup, at runtime, or both. Program options specified on the command line follow these rules: Options ...