PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
Warning Setting the max_digest_length system variable to zero disables digest production, which also disables server functionality that requires digests. The MySQL server is capable of maintaining statement digest information. The digesting process ...
https://dev.mysql.com/doc/refman/5.7/en/populating-spatial-columns.html
In a C program, you can escape a binary value using mysql_real_escape_string_quote() and include the result in a query string that is sent to the server. After you have created spatial columns, you can populate them with spatial data. Values should ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-decimal-characteristics.html
For a full explanation of the internal format of DECIMAL values, see the file strings/decimal.c in a MySQL source distribution. The format is explained (with an example) in the decimal2bin() function. This section discusses the characteristics of ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
Parameter markers can be used only where data values should appear, and they cannot be used for SQL keywords, identifiers, functions, and so on. To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, ...
https://dev.mysql.com/doc/refman/5.7/en/scalar-subqueries.html
For example, LIMIT requires literal integer arguments, and LOAD DATA requires a literal string file name. A scalar subquery can be part of an expression, but remember the parentheses, even if the subquery is an operand that provides an argument for ... In its simplest form, a subquery is a scalar subquery that returns a single ...
https://dev.mysql.com/doc/refman/5.7/en/union.html
Extra columns can provide other identifying information as well, such as a string that indicates a table name. UNION queries with an aggregate function in an ORDER BY clause are rejected with an ER_AGGREGATE_ORDER_FOR_UNION error. [UNION [ALL | ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-choosing-id.html
The number member of the MY_CHARSET_INFO data structure returned by the mysql_get_character_set_info() C API function. To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for ...
https://dev.mysql.com/doc/refman/5.7/en/alter-database.html
See Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or collation for a database, any stored routines that are to use the new defaults must be dropped and recreated. ALTER {DATABASE | ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-generated-columns.html
As of MySQL 5.7.10, if expression evaluation causes truncation or provides incorrect input to a function, the ALTER TABLE statement terminates with an error and the DDL operation is rejected. ALTER TABLE operations permitted for generated columns ...
https://dev.mysql.com/doc/refman/5.7/en/any-in-some-subqueries.html
The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is FALSE if table t2 contains (20,10), or if table t2 is empty. The expression is unknown (that is, NULL) if table t2 ...