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/using-systemd.html
This script assists in creating the error log file only if the log location matches a pattern (/var/log/mysql*.log for RPM platforms, /var/log/mysql/*.log for Debian platforms). For example: [Service] LimitNOFILE=max_open_files Nice=nice_level ...If ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installation-windows-path.html
Dismiss this dialogue, and each dialogue in turn, by clicking OK until all of the dialogues that were opened have been dismissed. This includes the servers, the mysql client, and all MySQL command-line utilities such as mysqladmin and mysqldump.
https://dev.mysql.com/doc/refman/8.0/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. However, this conversion is subject to the following exceptions: When you compare two columns When you compare a DATE, TIME, DATETIME, or TIMESTAMP column ...For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric context and vice ...
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 ...