PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html
XPath expressions used with these functions support user variables and local stored program variables. User variables are weakly checked; variables local to stored programs are strongly checked (see also Bug #26518): User variables (weak checking).
https://dev.mysql.com/doc/refman/8.0/en/commit.html
Note Within all stored programs (stored procedures and functions, triggers, and events), the parser treats BEGIN [WORK] as the beginning of a BEGIN ... You must use COMMIT to store your changes to disk or ROLLBACK to ignore the changes. (If ...SET ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
That is true for names of cursors, conditions, procedures, functions, savepoints, stored routine parameters, stored program local variables, and plugins. The following statement would not work because it refers to a table both as my_table and as ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
How do I back up and restore an NDB Cluster? A.10.41. How much RAM do I need to use NDB Cluster? Is it possible to use disk memory at all? NDB Cluster was originally implemented as in-memory only, but all versions currently available also provide ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
Thus, there may be gaps in the values stored in an AUTO_INCREMENT column of a table. If the AUTO_INCREMENT value becomes larger than the maximum integer for the specified integer type In all lock modes (0, 1, and 2), the behavior of the ... InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
Note Before setting up the daemon_memcached plugin, consult Section 17.20.5, “Security Considerations for the InnoDB memcached Plugin” to understand the security procedures required to prevent unauthorized access. When you restart MySQL, get ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html
This behavior on the server side comes into play for multiple-statement execution (see Multiple Statement Execution Support), and for parsing the body of stored procedures and functions, triggers, and events (see Section 27.1, “Defining Stored ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-summary-tables.html
Each row summarizes events for a given stored program (stored procedure or function, trigger, or event). The events_statements_summary_by_program table has these additional summary columns: COUNT_STATEMENTS, SUM_STATEMENTS_WAIT, MIN_STATEMENTS_WAIT, ... The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/8.0/en/select-into.html
For the INTO var_list variant: var_list names a list of one or more variables, each of which can be a user-defined variable, stored procedure or function parameter, or stored program local variable. INTO form of SELECT enables a query result to be ...Column and line terminators can be specified to produce a specific output ...
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
This includes the values displayed by functions such as NOW() or CURTIME(), and values stored in and retrieved from TIMESTAMP columns. Nor are values in those data types stored in UTC; the time zone applies for them only when converting from ...