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/signal.html
SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. SIGNAL Overview Signal Condition Information Items Effect of Signals on Handlers, Cursors, and Statements SIGNAL Overview The condition_value ...Also, it provides control over the error's characteristics (error number, SQLSTATE value, ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
NDB (also known as NDBCLUSTER): This clustered database engine is particularly suited for applications that require the highest possible degree of uptime and availability. Storage engines are MySQL components that handle the SQL operations for ...
https://dev.mysql.com/doc/refman/8.0/en/charset-literal.html
Every character string literal has a character set and a collation. For the simple statement SELECT 'string', the string has the connection default character set and collation defined by the character_set_connection and collation_connection system ...It tells the parser, “the string that follows uses character set charset_name.” An introducer does not change the string to the introducer character set like CONVERT() would ...
https://dev.mysql.com/doc/refman/8.0/en/commit.html
Important Many APIs used for writing MySQL client applications (such as JDBC) provide their own methods for starting transactions that can (and sometimes should) be used instead of sending a START TRANSACTION statement from the client. This means ...
https://dev.mysql.com/doc/refman/8.0/en/connectors-apis.html
Both Connectors and the APIs enable you to connect and execute MySQL statements from another language or environment, including ODBC, Java (JDBC), C++, Python, Node.js, PHP, Perl, Ruby, and C. Connector/J provides driver support for connecting to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transactions.html
In general, you should avoid transactions that update both transactional and nontransactional tables in a replication environment. A statement that references both nontransactional and transactional tables and updates any of the tables involved is ...You should also avoid using any statement that accesses both transactional (or temporary) and nontransactional tables and writes to any of ...The server uses ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
validate_password.dictionary_file can be set at runtime and assigning a value causes the named file to be read without a server restart. This section describes the system and status variables that validate_password provides to enable its operation ...This applies only when changing an existing password, and has no effect when setting a user account's initial ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-handling-nulls.html
This means that treatment of NULL varies between partitioning of different types, and may produce behavior which you do not expect if you are not prepared for it. This being the case, we discuss in this section how each MySQL partitioning type ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
For example: mysql> CREATE TABLE test (a INT NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (a), KEY(b)) -> ENGINE=InnoDB SELECT b,c FROM test2; This creates an InnoDB table with three columns, a, b, and c. The ENGINE option is part of the CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/fips-mode.html
At runtime, the OpenSSL library and OpenSSL FIPS Object Module must be available as shared (dynamically linked) objects. MySQL supports FIPS mode when a supported OpenSSL library and FIPS Object Module are available on the host system. This ...FIPS ...