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/linux-installation-native.html
This section provides basic instructions for installing MySQL using those package management systems. This can mean that you install a large number of packages in addition to the main MySQL package. You can manually start and stop the server using: ... Many Linux distributions include a version of the MySQL server, client tools, and development components in their native software repositories and can be installed with the platforms' standard package management ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation.html
In this case, rebuild any such indexes to avoid problems such as incorrect query results. Additional Resources Example showing how to add a collation for full-text searches: Section 14.9.7, “Adding a User-Defined Collation for Full-Text ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE option. You can use OPTIMIZE TABLE to analyze the table and pack it into a smaller format (for a reason to use OPTIMIZE TABLE, see ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-effect.html
latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...The first ...
https://dev.mysql.com/doc/refman/8.0/en/charset-gb18030.html
Searches for ligatures also match uppercase ligatures when using the gb18030_unicode_520_ci collation. Use this collation if you need to ensure that ligatures are sorted correctly. In MySQL, the gb18030 character set corresponds to the “Chinese ...
https://dev.mysql.com/doc/refman/8.0/en/charset-restrictions.html
However, you can perform IN BOOLEAN MODE searches on the column without an index. Identifiers are stored in mysql database tables (user, db, and so forth) using utf8mb3, but identifiers can contain only characters in the Basic Multilingual Plane ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. This character set is deprecated in MySQL 8.0, and you should use utf8mb4 instead. Deprecated in MySQL 8.0.28; you should expect ...
https://dev.mysql.com/doc/refman/8.0/en/charset-we-sets.html
DIN-1 is called the “dictionary collation” and DIN-2 is called the “phone book collation.” For an example of the effect this has in comparisons or when doing searches, see Section 12.8.6, “Examples of the Effect of Collation”. This means ... Western European character sets cover most West European languages, such as French, Spanish, Catalan, Basque, Portuguese, Italian, Albanian, Dutch, German, Danish, Swedish, Norwegian, Finnish, Faroese, Icelandic, Irish, Scottish, and ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
From an efficiency perspective, this avoids unnecessary I/O when you issue large numbers of consecutive INSERT, UPDATE, or DELETE statements. From a safety perspective, this allows you to issue a ROLLBACK statement to recover lost or garbled data if ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...