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/create-table-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. Prior to MySQL 8.0.16, if the CONSTRAINT symbol clause was not defined, or a symbol ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... The ...Certain ...
https://dev.mysql.com/doc/refman/8.0/en/security-guidelines.html
Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security mistakes. In discussing security, it is necessary to consider fully protecting the entire server host (not just the MySQL server) ...We do not cover all aspects of availability and fault tolerance ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
This option can be applied to any blob column type supported by MySQL except TINYBLOB or TINYTEXT (BLOB, MEDIUMBLOB, LONGBLOB, TEXT, MEDIUMTEXT, LONGTEXT). Using MAX_ROWS to force the number of partitions is deprecated but continues to be supported ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/fips-mode.html
MySQL supports FIPS mode when a supported OpenSSL library and FIPS Object Module are available on the host system. System Requirements for FIPS Mode in MySQL For MySQL to support FIPS mode, these system requirements must be satisfied: MySQL must be ...FIPS mode on the server side applies to cryptographic operations performed by the ...
https://dev.mysql.com/doc/refman/8.0/en/server-side-help-support.html
MySQL Server supports a HELP statement that returns information from the MySQL Reference Manual (see Section 15.8.3, “HELP Statement”). This information is stored in several tables in the mysql schema (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.0/en/set-operations.html
A query block, sometimes also known as a simple table, is any SQL statement that returns a result set, such as SELECT. MySQL 8.0 (8.0.19 and later) also supports TABLE and VALUES statements. This is not supported in MySQL.) MySQL has long supported ... Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple query blocks into a single ...
https://dev.mysql.com/doc/refman/8.0/en/testing-server.html
This section assumes that your current location is the MySQL installation directory and that it has a bin subdirectory containing the MySQL programs used here. That enables your shell (command interpreter) to find MySQL programs properly, so that ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
HeartbeatIntervalDbDb: Time between data node-to-data node heartbeats; data node considered dead after 3 missed heartbeats. KeepAliveSendInterval: Time between keep-alive signals on links between data nodes, in milliseconds. LcpScanProgressTimeout: ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-logs-cluster-log.html
CommunicationOpened Connection 8 INFO Node mgm_node_id: Node api_node_id: API version The API node having node ID api_node_id has connected to management node mgm_node_id using NDB API version version (generally the same as the MySQL version number). LCPFragmentCompleted Checkpoint 11 INFO Node node_id: ACC Blocked num_1 and TUP Blocked num_2 times last second Undo logging is blocked because the log buffer is close to ...