PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
Name Conflicts within Stored Routines The same identifier might be used for a routine parameter, a local variable, and a table column. The behavior that variables take precedence over table columns is nonstandard. However, the time shown in the ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
If the first argument is a constant string and the second is a column of type SET, the FIND_IN_SET() function is optimized to use bit arithmetic. For example, '41' is stored into a CHAR(3) column as '41 ' and retrieved as '41' (with the trailing pad ...For functions that operate on string positions, the first position is ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). The following table lists each built-in (native) function and operator and provides a short description of each one. For a ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
For comparisons of strings with column values, collation_connection does not matter because columns have their own collation, which has a higher collation precedence (see Section 10.8.4, “Collation Coercibility in Expressions”). This includes ...
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
The rounded values are also used by the NDB kernel for calculating Information Schema FILES column values and other purposes. For an NDB table assigned to a tablespace, only those columns which are not indexed are stored on disk, and actually use ...
https://dev.mysql.com/doc/refman/5.7/en/datetime.html
In particular, any fractional part in a value inserted into a DATETIME or TIMESTAMP column is stored rather than discarded. MySQL does not accept TIMESTAMP values that include a zero in the day or month column or values that are not a valid date. If ...This section describes their characteristics, how they are similar, and how they ...
https://dev.mysql.com/doc/refman/5.7/en/fixed-point-types.html
In a DECIMAL column declaration, the precision and scale can be (and usually is) specified. Standard SQL requires that DECIMAL(5,2) be able to store any value with five digits and two decimals, so values that can be stored in the salary column range ... The DECIMAL and NUMERIC types store exact numeric data ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
MySQL also determines when to evaluate functions based on types of arguments, whether the arguments are table columns or constant values. A deterministic function that takes a table column as argument must be evaluated whenever that column changes ...A function is nondeterministic if, given fixed values for its arguments, it can return different results for different ...
https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html
With ICP enabled, and if parts of the WHERE condition can be evaluated by using only columns from the index, the MySQL server pushes this part of the WHERE condition down to the storage engine. ICP is not supported with secondary indexes created on ... Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-per-index-table.html
In this context, the table data is treated as just another index, one that happens to contain all the columns: the clustered index. The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables have these columns: DATABASE_NAME The schema ... The ...