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-hash.html
Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of partitions. To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. If an event is produced from an instrument that has TIMED = NO, timing information is not collected, and TIMER_START, ...The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
If no row has the statement digest value for the statement that just completed, and the table is full, the statistics for the statement that just completed are added to a special “catch-all” row with DIGEST = NULL, which is created if necessary.
https://dev.mysql.com/doc/refman/5.7/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, (value_list)] ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-main.html
row *************************** Id: 2 User: root Host: localhost:32931 db: NULL Command: Binlog Dump Time: 94 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Here, thread 2 is a Binlog Dump thread that services a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-get-config.html
Given a configuration option name, returns the option value from the sys_config table, or the provided default value (which may be NULL) if the option does not exist in the table. If sys_get_config() returns the default value and that value is ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. This section describes the syntax for account names, including special ...
https://dev.mysql.com/doc/refman/5.7/en/non-typed-operators.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an ...
https://dev.mysql.com/doc/refman/5.7/en/loading-tables.html
For missing values (such as unknown sexes or death dates for animals that are still living), you can use NULL values. Suppose that Diane gets a new hamster named “Puffball.” You could add a new record using an INSERT statement like this: mysql> ...Suppose that your pet records can be described as shown ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
For example, to delete rows that exist in t1 that have no match in t2, use a LEFT JOIN: DELETE t1 FROM t1 LEFT JOIN t2 ON t1.id=t2.id WHERE t2.id IS NULL; The syntax permits .* after each tbl_name for compatibility with Access. DELETE is a DML ...