PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html
Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit ...The ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-collations.html
The example also shows how to use the INFORMATION_SCHEMA COLLATIONS table to determine the pad attribute for collations. This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature-windows.html
The signature file must have the same name as the packaged file but with an appended .asc extension, as shown by the example in the following table. Table 2.2 MySQL Package and Signature Files for MySQL Installer for Microsoft Windows File Type File ... The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using ...
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html
Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.0/en/connectors-apis.html
Connector/NET enables developers to create .NET applications that connect to MySQL. Table 31.1, “MySQL APIs and Interfaces” lists many of the libraries and interfaces available for MySQL. Table 31.1 MySQL APIs and Interfaces Environment API Type ... MySQL Connectors provide connectivity to the MySQL server for client ...
https://dev.mysql.com/doc/refman/8.0/en/document-store.html
For example, when you create documents describing products, you do not need to know and define all possible attributes of any products before storing and operating with the documents. This differs from working with a relational database and storing ... This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using ...
https://dev.mysql.com/doc/refman/8.0/en/error-interfaces.html
SHOW ENGINE INNODB STATUS statement output includes information about the most recent foreign key error if a CREATE TABLE statement for an InnoDB table fails. Error messages can originate on the server side or the client side, and each error ...
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range ...The ...
https://dev.mysql.com/doc/refman/8.0/en/gone-away.html
If you want to create a bug report regarding this problem, be sure that you include the following information: Indicate whether the MySQL server died. If a specific query kills mysqld and the tables involved were checked with CHECK TABLE before you ... This section also covers the related Lost connection to server during query ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-change-primary.html
You can identify the current primary using the MEMBER_ROLE column in the Performance Schema table replication_group_members, or the group_replication_primary_member status variable. This section explains how to change which member of a ...