PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/arithmetic-functions.html
If any of the operands of a +, -, /, *, % is a real or string value, the precision of the result is the precision of the operand with the maximum precision. (See Section 11.1, “Numeric Data Types”.) / Division: mysql> SELECT 3/5; -> 0.60 ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
To convert strings in other orders to year-month-day order, the STR_TO_DATE() function may be useful. MySQL permits you to store a “zero” value of '0000-00-00' as a “dummy date.” In some cases, this is more convenient than using NULL values, ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-mecab.html
The mecab_rc_file option is not recognized by MySQL until the MeCaB parser plugin is installed but it must be set before attempting to install the MeCaB parser plugin. The built-in MySQL full-text parser uses the white space between words as a ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
A combined character is considered different from the same character written with a single unicode character in string comparisons, and the two characters are considered to have a different length (for example, as returned by the CHAR_LENGTH() ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to perform. Use the private key to encrypt data and the public key to decrypt it This requires that the members of the key ...
https://dev.mysql.com/doc/refman/5.7/en/error-interfaces.html
Error messages can originate on the server side or the client side, and each error message includes an error code, SQLSTATE value, and message string, as described in Section B.1, “Error Message Sources and Elements”. For error checking from ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-options.html
MySQL supports the following keyring-related command-line options: --keyring-migration-destination=plugin Command-Line Format --keyring-migration-destination=plugin_name Introduced 5.7.21 Type String The destination keyring plugin for key migration. --keyring-migration-host=host_name Command-Line Format --keyring-migration-host=host_name Introduced 5.7.21 Type String Default Value localhost The host location of the running server that is currently using one of the key migration ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-secure-installation.html
--defaults-group-suffix=str Command-Line Format --defaults-group-suffix=str Type String Read not only the usual option groups, but also groups with the usual names and a suffix of str. --password=password, -p password Command-Line Format ... This ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Thus column names, database names, user names, version names, and most of the string results from SHOW are metadata. If character_set_results is set to NULL, no conversion is performed and the server returns metadata using its original character set ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-general-options.html
--debug=debug_options, -# debug_options Command-Line Format --debug[=debug_options] Type String Default Value d:t:o,/tmp/myisamchk.trace Write a debugging log. --defaults-group-suffix=str Command-Line Format --defaults-group-suffix=str Type String ... The options described in this section can be used for any type of table maintenance operation performed by ...