PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html
WHERE subquery_where) MySQL evaluates queries “from outside to inside.” That is, it first obtains the value of the outer expression outer_expr, and then runs the subquery and captures the rows that it produces. WHERE subquery_where AND ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html
TIME_ZONE The event time zone, which is the time zone used for scheduling the event and that is in effect within the event as it executes. EVENT_TYPE The event repetition type, either ONE TIME (transient) or RECURRING (repeating). EXECUTE_AT For a ... The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL accounts. In this case, if a client connects as user1 from the local host, USER() and CURRENT_USER() return different values: mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. In ...
https://dev.mysql.com/doc/refman/8.0/en/account-management-statements.html
MySQL account information is stored in the tables of the mysql system schema. This database and the access control system are discussed extensively in Chapter 7, MySQL Server Administration, which you should consult for additional details. When the ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-comments.html
Standard SQL uses the C syntax /* this is a comment */ for comments, and MySQL Server supports this syntax as well. MySQL also support extensions to this syntax that enable MySQL-specific SQL to be embedded in the comment; see Section 11.7, ...In ...
https://dev.mysql.com/doc/refman/8.0/en/checking-rpm-signature.html
To import the MySQL public key into the RPM keyring, first obtain the key, then use rpm --import to import the key. For example: $> gpg --export -a 3a79bd29 > 3a79bd29.asc $> rpm --import 3a79bd29.asc Alternatively, rpm also supports loading the key ...RPM 4.1 no longer uses your personal GPG keyring (or GPG ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin.html
The clone plugin, introduced in MySQL 8.0.17, permits cloning data locally or from a remote MySQL server instance. The cloned data comprises a fully functional data directory, which permits using the clone plugin for MySQL server provisioning.
https://dev.mysql.com/doc/refman/8.0/en/federated-create-connection.html
For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ... To ...
https://dev.mysql.com/doc/refman/8.0/en/functions.html
This chapter describes the built-in functions and operators that are permitted for writing expressions in MySQL. For information about loadable functions and stored functions, see Section 7.7, “MySQL Server Loadable Functions”, and Section 27.2, ... Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE statement, or in SET ...