PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-foreign-keys.html
The MATCH clause in the SQL standard controls how NULL values in a composite (multiple-column) foreign key are handled when comparing to a primary key in the referenced table. (It is possible to implement other semantics using triggers.) MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
Blackhole Engine and Auto Increment Columns The Blackhole engine is a no-op engine. This should be borne in mind when considering the behavior of primary key columns that auto increment. The engine does not automatically increment field values, and ... The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store ...
https://dev.mysql.com/doc/refman/5.7/en/connection-access.html
The server performs identity and credentials checking using columns in the user table, accepting the connection only if these conditions are satisfied: The client host name and user name match the Host and User columns in some user table row. The ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
A collection is a set of one or more columns included in a FULLTEXT index. For each row in the table, MATCH() returns a relevance value; that is, a similarity measure between the search string and the text in that row in the columns named in the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
The host_cache table has these columns: IP The IP address of the client that connected to the server, expressed as a string. If HOST_VALIDATED is YES, the HOST column is used as the host name corresponding to the IP so that additional calls to DNS ... The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-summary-tables.html
Each stage summary table has one or more grouping columns to indicate how the table aggregates events. Event names refer to names of event instruments in the setup_instruments table: events_stages_summary_by_account_by_event_name has EVENT_NAME, ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-decimal-characteristics.html
This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range ...The ranges of values for the arguments are as follows: M is the maximum number of digits (the ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-status.html
For the connection metadata repository, the following table shows the correspondence between the columns in the mysql.slave_master_info table, the columns displayed by SHOW SLAVE STATUS, and the lines in the master.info file. A replica server ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-redundant-indexes.html
In the following column descriptions, the dominant index is the one that makes the redundant index redundant. The schema_redundant_indexes view has these columns: table_schema The schema that contains the table. The x$schema_flattened_keys view has ... The schema_redundant_indexes view displays indexes that duplicate other indexes or are made redundant by ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
The BINARY operator in expressions differs in effect from the BINARY attribute in character column definitions. For a character column defined with the BINARY attribute, MySQL assigns the table default character set and the binary (_bin) collation ... Table 12.15 Cast Functions and Operators Name Description BINARY Cast a string to a binary string CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...