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/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-summary-tables.html
The error summary tables have these indexes: events_errors_summary_by_account_by_error: Primary key on (USER, HOST, ERROR_NUMBER) events_errors_summary_by_host_by_error: Primary key on (HOST, ERROR_NUMBER) events_errors_summary_by_thread_by_error: ... The Performance Schema maintains summary tables for aggregating statistical information about server errors (and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-memory-summary-tables.html
The memory summary tables have these indexes: memory_summary_by_account_by_event_name: Primary key on (USER, HOST, EVENT_NAME) memory_summary_by_host_by_event_name: Primary key on (HOST, EVENT_NAME) memory_summary_by_thread_by_event_name: Primary ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-stage-summary-tables.html
The stage summary tables have these indexes: events_stages_summary_by_account_by_event_name: Primary key on (USER, HOST, EVENT_NAME) events_stages_summary_by_host_by_event_name: Primary key on (HOST, EVENT_NAME) ... The Performance Schema maintains ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-summary-tables.html
The transaction summary tables have these indexes: events_transactions_summary_by_account_by_event_name: Primary key on (USER, HOST, EVENT_NAME) events_transactions_summary_by_host_by_event_name: Primary key on (HOST, EVENT_NAME) ... The Performance ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html
mysql> CREATE TABLE opening_lines ( FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, opening_line TEXT(500), author VARCHAR(200), title VARCHAR(200) ) ENGINE=InnoDB; If you choose to define the FTS_DOC_ID column yourself, you are ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-nodes-groups.html
This is subject to the following limitations: Only the KEY and LINEAR KEY partitioning schemes are supported in production with NDB tables. This section discusses the manner in which NDB Cluster divides and duplicates data for storage. A number of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html
The threads table has these indexes: Primary key on (THREAD_ID) Index on (NAME) Index on (PROCESSLIST_ID) Index on (PROCESSLIST_USER, PROCESSLIST_HOST) Index on (PROCESSLIST_HOST) Index on (THREAD_OS_ID) Index on (RESOURCE_GROUP) TRUNCATE TABLE is ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-functions.html
Prior to MySQL 8.0.19, the functions treat string arguments as binary strings (which means they do not distinguish lettercase), and string return values are binary strings. If a MySQL Enterprise Data Masking and De-Identification function is invoked ...