PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html
InnoDB can handle composing and decomposing multiple column values into a single memcached item value, reducing the amount of string parsing and concatenation required in your application. For example, you can store the string value 2|4|6|8 in the ...The combination of InnoDB tables and memcached offers advantages over using either by ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
For column values calculated as a result of string expressions (such as those that invoke a string-valued function), the filesort algorithm cannot tell the maximum length of expression values, so it must allocate max_sort_length bytes for each tuple. For example, if tuples store values of long string columns and you increase the value of max_sort_length, the size of sort buffer tuples increases as well and may require you to increase ... This section describes ...
https://dev.mysql.com/doc/refman/5.7/en/year.html
YEAR accepts input values in a variety of formats: As 4-digit strings in the range '1901' to '2155'. As 1- or 2-digit strings in the range '0' to '99'. To insert zero and have it be interpreted as 2000, specify it as a string '0' or '00'. As the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-binary-collations.html
This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary. A ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >). Important Revoking the FILE privilege (or not granting it in the first place) keeps the user only from ...LOAD XML acts as the complement of running the mysql client in XML output mode (that is, starting the client with the --xml ...
https://dev.mysql.com/doc/refman/5.7/en/prepare.html
preparable_stmt is either a string literal or a user variable that contains the text of the SQL statement. The ? characters should not be enclosed within quotation marks, even if you intend to bind them to string values. A statement prepared in ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
In addition to the provided SQL functionality, similar to mysql, MySQL Shell provides scripting capabilities for JavaScript and Python and includes APIs for working with MySQL. replace A utility program that performs string replacement in the input ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key constraint names that begin with the string “tbl_name_ibfk_” to reflect the new table name. InnoDB interprets foreign ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
The implicit default value is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. The mysql_info() C API function returns the number of rows that were matched and updated and the number of ... UPDATE is a DML statement that modifies rows in a ...
https://dev.mysql.com/doc/refman/5.7/en/charset-introducer.html
A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a string that uses a particular character set and collation: [_charset_name] literal [COLLATE ...Escapes are always interpreted by the parser according to the character set given by ...