PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/index-page-merge-threshold.html
row *************************** Table: t2 Create Table: CREATE TABLE `t2` ( `id` int(11) DEFAULT NULL, KEY `id_index` (`id`) COMMENT 'MERGE_THRESHOLD=40' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Note A MERGE_THRESHOLD value defined at the index level ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...
https://dev.mysql.com/doc/refman/5.7/en/show-warnings.html
mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> INSERT INTO t1 VALUES(10,'mysql'), (NULL,'test'), (300,'xyz'); Query OK, 3 rows affected, 3 warnings (0.00 sec) Records: 3 Duplicates: 0 Warnings: 3 ... SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions-object-shapes.html
If g1 is a Polygon or a MultiPolygon, or if g2 is a Point or a MultiPoint, the return value is NULL. Returns NULL if g1 is a Polygon or a MultiPolygon, or if g2 is a Point or a MultiPoint. If either argument is NULL or an empty geometry, the return ... The OpenGIS specification defines the following functions to test the relationship between two geometry values g1 and g2, using precise object ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html
Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string containing an SQL statement or a file containing statements. --create=value Command-Line Format --create=value Type String The ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geojson-functions.html
mysql> SELECT ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2); +-------------------------------------------------------------+ | ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2) | ... This section describes functions for ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
General-Purpose Masking Functions mask_inner() and mask_outer() are general-purpose functions that mask parts of arbitrary strings based on position within the string: mask_inner() masks the interior of its string argument, leaving the ends unmasked. Converting the value to a binary string ensures that the function sees an argument of length ... Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
Arguments can refer to predefined variables, event fields, or string or numeric constants. The following list describes the permitted predefined functions for function items: audit_log_exclude_accounts_is_null() Checks whether the ...For information ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
With this modifier, certain characters have special meaning at the beginning or end of words in the search string. Specify the search words within a double-quoted string immediately before the @distance operator, for example, MATCH(col1) ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-launchd.html
macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is 24710a27dc7a28fb7ee6d825129cd3cf. To enable the launchd service, you can either: ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'] AS (expr) indicates that the column is generated and defines the ...