PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/stored-routines.html
MySQL follows the SQL:2003 syntax for stored routines, which is also used by IBM's DB2. For answers to some commonly asked questions regarding stored routines in MySQL, see Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”. A stored ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions-charset.html
MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-tables.html
Note Symbolic link support as described here, along with the --symbolic-links option that controls it, and is deprecated; expect these to be removed in a future version of MySQL. To instruct a running MySQL server to perform the symlinking, use the ...For files used by tables for other storage engines, you may get strange problems if you try to use symbolic ...
https://dev.mysql.com/doc/refman/8.0/en/sys-format-statement.html
Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the result. Otherwise, the middle part of the string is replaced by an ellipsis (...). This ...
https://dev.mysql.com/doc/refman/8.0/en/table-scan-avoidance.html
The output from EXPLAIN shows ALL in the type column when MySQL uses a full table scan to resolve a query. You are comparing indexed columns with constant values and MySQL has calculated (based on the index tree) that the constants cover too large ...This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a key ...
https://dev.mysql.com/doc/refman/8.0/en/views.html
Additional Resources You may find the MySQL User Forums helpful when working with views. For answers to some commonly asked questions regarding views in MySQL, see Section A.6, “MySQL 8.0 FAQ: Views”. Views are stored queries that when invoked ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
For faster execution, MySQL always uses inverse aggregation when it is safe: For floating-point values, inverse aggregation is not always safe and might result in loss of precision. Window functions affect the strategies the optimizer considers: ...
https://dev.mysql.com/doc/refman/8.0/en/working-with-null.html
In MySQL, 0 or NULL means false and anything else means true. The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. This special ...
https://dev.mysql.com/doc/refman/8.0/en/zlib-decompress.html
The zlib_decompress utility decompresses mysqlpump output that was created using ZLIB compression. Note zlib_decompress is deprecated as of MySQL 8.0.34; expect it to be removed in a future version of MySQL. This is because the associated mysqlpump ...In this case, the system openssl zlib command can be used ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. The following table lists each built-in (native) function and operator and provides a short description of each one. ->> Return value ...