PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
As of MySQL 8.0.22, CREATE USER fails with an error if any account to be created is named as the DEFINER attribute for any stored object. (That is, the statement fails if creating an account would cause the account to adopt a currently orphaned ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
Different storage engines represent data types and store raw data differently. For BLOB and TEXT data, the information is stored internally in a different area of memory than the row buffer. DATETIME is packed more efficiently, requiring 5 rather ...
https://dev.mysql.com/doc/refman/8.0/en/create-view.html
If the DEFINER clause is present, the privileges required depend on the user value, as discussed in Section 27.6, “Stored Object Access Control”. Within a stored program, the SELECT statement cannot refer to program parameters or local variables. This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, FOR SHARE, LOCK IN SHARE MODE, and ...
https://dev.mysql.com/doc/refman/8.0/en/tuning-trace-purging.html
Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement ...Such a SET statement has the following effects: All traces previously stored are cleared from ...A user who wants to see the trace of a different substatement can enable or disable tracing for the ...
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/create-event.html
If the DEFINER clause is present, the privileges required depend on the user value, as discussed in Section 27.6, “Stored Object Access Control”. In general, the rules governing event names are the same as those for names of stored routines. The ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
(NDB 8.0.13) This global parameter can be set only in the [ndbd default] section, and defines the number of fragment replicas for each table stored in the cluster. Warning Setting NoOfReplicas to 1 means that there is only a single copy of all ...
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 ...