PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-native.html
The database tables are automatically created for you, if they do not already exist. Many Linux distributions include a version of the MySQL server, client tools, and development components in their native software repositories and can be installed ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by Oracle. There are two sources for obtaining them, for the Community Edition of MySQL: From the MySQL software repositories: The MySQL Yum ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >). LOAD XML acts as the complement of running the mysql client in XML output mode (that is, starting the ...
https://dev.mysql.com/doc/refman/5.7/en/locking-service.html
For example, if the statement fails part way through and rolls back, locks acquired up to the point of failure still exist. MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable ...
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html
You can atomically rename a log table (to perform log rotation, for example) using the following strategy: USE mysql; DROP TABLE IF EXISTS general_log2; CREATE TABLE general_log2 LIKE general_log; RENAME TABLE general_log TO general_log_backup, ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-launchd.html
Upgrading also replaces your existing launchd file of the same name. macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is ...
https://dev.mysql.com/doc/refman/5.7/en/merge-storage-engine.html
Note A known issue exists where indexes on the same columns must be in identical order, in both the MERGE table and the underlying MyISAM table. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
ANY_VALUE() is also useful if functional dependence exists between columns but MySQL cannot determine it. The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ...
https://dev.mysql.com/doc/refman/5.7/en/multibyte-characters.html
The existing character sets provide the best documentation and examples to show how these functions are implemented. If you want to add support for a new character set named MYSET that includes multibyte characters, you must use multibyte character ...