PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/partitioning-list.html
Note In MySQL 5.7, it is possible to match against only a list of integers (and possibly NULL—see Section 22.2.7, “How MySQL Partitioning Handles NULL”) when partitioning by LIST. List partitioning in MySQL is similar to range partitioning in ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-info.html
row *************************** id: 1 select_type: SIMPLE table: trb1 partitions: p0,p1,p2,p3 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 10 Extra: Using filesort In this case, all four partitions are searched. This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
An extra “NULL row” provides additional information about undo log files. NDB Cluster Disk Data storage is implemented using a number of Disk Data objects. These include the following: Tablespaces act as containers for other Disk Data objects.
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
--replicate-do-db=db_name Command-Line Format --replicate-do-db=name Type String Creates a replication filter using the name of a database. --replicate-ignore-db=db_name Command-Line Format --replicate-ignore-db=name Type String Creates a ... This ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
Each of those functions, if successful, returns a binary string indicating what action occurred. Version Tokens treats token names and values as binary strings, so comparisons are case-sensitive. Otherwise, an error occurs: mysql> SELECT ... Before ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
In the definition of an integer column, it is an alias for NOT NULL AUTO_INCREMENT UNIQUE. Implicit Default Handling If a data type specification includes no explicit DEFAULT value, MySQL determines the default value as follows: If the column can ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-mysql.html
If there is a short numeric primary key column in an InnoDB table, use it as the unique lookup key for memcached by converting the integer to a string value. In any query that performs arithmetic using column values, use the CAST() function to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
DIGEST The statement digest MD5 value as a string of 32 hexadecimal characters, or NULL if the statements_digest consumer is no. END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning.html
See Section 24.3.16, “The INFORMATION_SCHEMA PARTITIONS Table”, for more information; for some examples of queries against this table, see Section 22.2.7, “How MySQL Partitioning Handles NULL”. Note As of MySQL 5.7.17, the generic ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER Statement”. Here is a simple example that associates a ...