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/replication-setup-replicas.html
On the source, released the read lock: mysql> UNLOCK TABLES; On the replica, edited the MySQL configuration. If you are setting up a new replication environment using the data from a different existing database server to create a new source, run the ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.0/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.23, “CREATE VIEW Statement”). A view can be created from many kinds of SELECT statements. To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-usage.html
Creating Views that Display Masked Data If masked data from a table is used for multiple queries, it may be convenient to define a view that produces masked data. Suppose that a customer table containing customer records has these columns: id: ...
https://dev.mysql.com/doc/refman/8.0/en/drop-database.html
Dropping a database does not remove any TEMPORARY tables that were created in that database. TEMPORARY tables are automatically removed when the session that created them ends. DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all ...
https://dev.mysql.com/doc/refman/8.0/en/events-metadata.html
Value EVENTS Table SHOW EVENTS Execute at ETZ ETZ Starts ETZ ETZ Ends ETZ ETZ Last executed ETZ n/a Created STZ n/a Last altered STZ n/a . To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA database. The session time ...Event Scheduler Time Representation Each session in MySQL has a session time zone ...
https://dev.mysql.com/doc/refman/8.0/en/test-pluggable-authentication.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). For example: $> mysql --user=testuser --password Enter password: ... MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html
ssl: A directory that contains the certificate and key files required to establish a secure connection with the KMIP back end: CA.pem, cert.pem, and key.pem. The following procedure briefly summarizes the process of setting up keyring_okv for use ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET'); -> '2004-01-01 13:00:00' mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00'); -> '2004-01-01 22:00:00' Note To use named time zones such as 'MET' or 'Europe/Amsterdam', the ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
For InnoDB full-text search, this means that the index required on the FTS_DOC_ID column of the indexed table cannot be defined as a descending index. MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes ...