PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
Note Clauses for random password generation, password verification, and secondary passwords apply only to accounts that use an authentication plugin that stores credentials internally to MySQL. Plugin names are stored in the plugin column of the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-tables.html
Transactions and Stored Programs Transactions and stored program events are related as follows: Stored Procedures Stored procedures operate independently of transactions. A stored procedure can be started within a transaction, and a transaction can ...These tables store transaction events: events_transactions_current: The current transaction event for each ...Within the event ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
The object_type clause, if present, should be specified as TABLE, FUNCTION, or PROCEDURE when the following object is a table, a stored function, or a stored procedure. Stored Routine Privileges The ALTER ROUTINE, CREATE ROUTINE, EXECUTE, and GRANT ...Never alter the structure of tables in the mysql system schema in any manner except by means of the procedure described in Chapter 3, Upgrading ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
MySQL supports built-in (native) functions, loadable functions, and stored functions. However, for these nonaffected function names, interpretation may vary in expression context: func_name () is interpreted as a built-in function if there is one ...This section describes how the server recognizes whether the name of a built-in function is used as a function call or as an identifier, and how the server determines which function to use in cases when functions of different types exist with a given ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-nodes-groups.html
An ndbd or ndbmtd process, which stores one or more fragment replicas—that is, copies of the partitions (discussed later in this section) assigned to the node group of which the node is a member. A node group consists of one or more nodes, and ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
parameter_type_elements: Information about stored procedure and function parameters, and about return values for stored functions. It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the ...The following discussion further subdivides the set of system tables into smaller ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified. CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 ... ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
Now, any rows whose store_id column value is greater than or equal to 16 (the highest value defined) are stored in partition p3. At some point in the future—when the number of stores has increased to 25, 30, or more—you can use an ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-digests.html
For each digest, a representative statement that produces the digest is stored as a sample. The copy of the normalized statement digest is stored in the appropriate Performance Schema tables, along with the SHA-256 hash value computed from the ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-usage.html
Grant the EXECUTE privilege for the firewall stored procedures in the mysql system database. These may invoke administrative functions, so stored procedure access also requires the privileges indicated earlier that are needed for those functions.