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/expressions.html
With PIPES_AS_CONCAT enabled, || is string concatenation, with a precedence between ^ and the unary operators. expr is treated as a string, so be careful if you specify a nonstring value with INTERVAL. This section lists the grammar rules that ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
The procs_priv table applies to stored routines (stored procedures and functions). A privilege granted at the routine level applies only to a single procedure or function. Table 6.5 procs_priv Table Columns Table Name procs_priv Scope columns Host ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
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/binary-log-mixed.html
When one or more tables with AUTO_INCREMENT columns are updated and a trigger or stored function is invoked. For example, this occurs when the statement creating a view uses the UUID() function. When running in MIXED logging format, the server ...
https://dev.mysql.com/doc/refman/5.7/en/date-calculations.html
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. MySQL provides ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
You can retrieve the most recent automatically generated AUTO_INCREMENT value with the LAST_INSERT_ID() SQL function or the mysql_insert_id() C API function. These functions are connection-specific, so their return values are not affected by another ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
If the value is func, the value used is the result of some function. To see which function, use SHOW WARNINGS following EXPLAIN to see the extended EXPLAIN output. The function might actually be an operator such as an arithmetic operator. The ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-installation.html
MySQL Enterprise Firewall installation is a one-time operation that installs the elements described in Section 6.4.6.1, “Elements of MySQL Enterprise Firewall”. Installation can be performed using a graphical interface or manually: On Windows, ...