PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
This may also be true for the names of built-in functions. However, by default, no whitespace is permitted in function invocations between the function name and the following ( character. This requirement enables the parser to distinguish whether ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html
It returns the exact string that can be used to re-create the named stored procedure. A similar statement, SHOW CREATE FUNCTION, displays information about stored functions (see Section 13.7.5.8, “SHOW CREATE FUNCTION Statement”). If you do not ... SHOW CREATE PROCEDURE proc_name This statement is a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-types.html
The specification describes a set of SQL geometry types, as well as functions on those types to create and analyze geometry values. MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for ... The ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
All credentials are stored in the authentication_string column, including those formerly stored in the Password column. If performing an in-place upgrade to MySQL 5.7.6 or later, run mysql_upgrade as directed by the in-place upgrade procedure to ...
https://dev.mysql.com/doc/refman/5.7/en/dbug-package.html
The effect of this default is: d: Enable output for all debug macros t: Trace function calls and exits i: Add PID to output lines o,/tmp/mysqld.trace, O,\mysqld.trace: Set the debug output file. Here are some example debug control strings as they ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
If the group is operating in multi-primary mode, shows an empty string. Handler_external_lock The server increments this variable for each call to its external_lock() function, which generally occurs at the beginning and end of access to a table ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
It can be an SQLSTATE value (a 5-character string literal) or a condition_name that refers to a named condition previously defined with DECLARE ... Valid simple_value_specification designators can be specified using stored procedure or function ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
For information about time zone settings in replication setups, see Section 16.4.1.15, “Replication and System Functions” and Section 16.4.1.31, “Replication and Time Zones”. Note If set to SYSTEM, every MySQL function call that requires a ... This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
To convert strings in other orders to year-month-day order, the STR_TO_DATE() function may be useful. For descriptions of functions that operate on temporal values, see Section 12.7, “Date and Time Functions”. However, with dates such as these, ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
In addition, query strings that are identical may be treated as different for other reasons. Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. This section describes how the query cache works when it is operational. Section 8.10.3.3, “Query Cache Configuration”, describes how to control whether it is ...