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/selecting-rows.html
String comparisons normally are case-insensitive, so you can specify the name as 'bowser', 'BOWSER', and so forth. As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, ...
https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html
For up-to-date information operating system file size limits, refer to the documentation specific to your operating system. Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production use with MySQL. You are using ... The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-troubleshooting.html
In this case, check the date for your mysql.h file and libmysqlclient.a library to verify that they are from the new MySQL distribution. A schema mismatch in a MySQL 5.7 instance between the .frm file of a table and the InnoDB data dictionary can ...If problems occur, such as that the new mysqld server does not start, verify that you do not have an old my.cnf file from your previous ...
https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...This means that if you search with col_name LIKE 'a%', you get all column values that start with A ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-set.html
Comparison and sorting are based on numeric byte values, rather than on numeric character code values (which for multibyte characters differ from numeric byte values). For information about the differences between the binary collation of the binary ... The binary character set is the character set for binary strings, which are sequences of ...
https://dev.mysql.com/doc/refman/8.0/en/charset-gb18030.html
In MySQL, the gb18030 character set corresponds to the “Chinese National Standard GB 18030-2005: Information technology — Chinese coded character set”, which is the official character set of the People's Republic of China (PRC). Case folding ...
https://dev.mysql.com/doc/refman/8.0/en/create-resource-group.html
This statement creates a new resource group and assigns its initial attribute values. The VCPU attribute indicates the CPU affinity; that is, the set of virtual CPUs the group can use: If VCPU is not given, the resource group has no CPU affinity and ... CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE] vcpu_spec: {N | M - N} CREATE RESOURCE GROUP is used for resource group management (see Section 7.1.16, “Resource ...
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
Descending indexes also make it possible for the optimizer to use multiple-column indexes when the most efficient scan order mixes ascending order for some columns and descending order for others. Descending indexes are supported for ordinary ...
https://dev.mysql.com/doc/refman/8.0/en/gpg-key-archived-packages.html
The following GPG public build key (keyID 3A79BD29) can be used to verify the authenticity and integrity of MySQL packages versions 8.0.28 through 8.0.35, 8.1.0, and 8.2.0. For signature checking instructions, see Section 2.1.4.2, “Signature ...
https://dev.mysql.com/doc/refman/8.0/en/handler.html
HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ... ] HANDLER tbl_name READ index_name { FIRST | NEXT | PREV | LAST } [ WHERE where_condition ] [LIMIT ...If you do not use an alias, but open the table using a table name qualified by the database name, further references must use the unqualified table ...