PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-options-variables.html
ndb_conflict_role can take any one of the values PRIMARY, SECONDARY, PASS, or NULL (the default). row *************************** id: 1 select_type: SIMPLE table: d type: ALL possible_keys: PRIMARY key: NULL key_len: NULL ref: NULL rows: 9 Extra: ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-innodb-bulk-data-loading.html
For optimal performance when loading data into an InnoDB FULLTEXT index, follow this set of steps: Define a column FTS_DOC_ID at table creation time, of type BIGINT UNSIGNED NOT NULL, with a unique index named FTS_DOC_ID_INDEX. For example: CREATE ... These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/9.7/en/option-tracker-component-functions.html
This argument cannot be null, although it can be an empty string. This argument is case-insensitive, and cannot be an empty string or null. This is a case-insensitive string, which cannot be null but can be an empty string. This can be an empty ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-firewall-groups-table.html
The value is NULL, or a non-NULL account that has the format user_name@host_name: If the value is NULL, the firewall records allowlist rules for statements received from any account that is a member of the group. If the value is non-NULL, the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-timing.html
If an enabled instrument is not timed, events produced by the instrument have NULL for the TIMER_START, TIMER_END, and TIMER_WAIT timer values. Events that have not yet completed have an END_EVENT_ID value of NULL. Events are collected by means of ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-expressions.html
By default, division by zero produces a result of NULL and no warning. sql_mode Value Result '' (Default) No warning, no error; i is set to NULL. With precision math, exact-value numbers are used as given whenever possible. For example, numbers in ...
https://dev.mysql.com/doc/refman/9.7/en/rename-table.html
row *************************** Table: t3 Create Table: CREATE TABLE `t3` ( `i1` int(11) DEFAULT NULL, `i2` int(11) DEFAULT NULL, CONSTRAINT `t3_chk_1` CHECK ((`i1` > 0)), CONSTRAINT `t3_chk_2` CHECK ((`i2` < 0)) ) ENGINE=InnoDB DEFAULT ... RENAME ...
https://dev.mysql.com/doc/refman/9.7/en/show-replica-status.html
In MySQL 9.7, this field is NULL (undefined or unknown) if the replication applier thread is not running, or if the applier thread has consumed all of the relay log and the replication receiver thread is not running. (In older versions of MySQL, ...
https://dev.mysql.com/doc/refman/9.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/9.7/en/spatial-relation-functions-mbr.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or an empty geometry, the return value is NULL. MBREquals() handles its arguments as described in the introduction to this ...