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/check-table.html
The storage method of the new DECIMAL data type changed between MySQL 5.0.3 and 5.0.5. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check views for ...
https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
The heartbeat interval interval is a decimal value having the range 0 to 4294967 seconds and a resolution in milliseconds; the smallest nonzero value is 0.001. ] CHANGE MASTER TO changes the parameters that the replica uses for connecting to the ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-logging-configuration.html
By inserting a decimal point, the value can be interpreted using the FROM_UNIXTIME() function: mysql> SELECT FROM_UNIXTIME(1515934443.7726520); +-----------------------------------+ | FROM_UNIXTIME(1515934443.7726520) | ... This section describes ...
https://dev.mysql.com/doc/refman/5.7/en/obtaining-loadable-function-information.html
Permitted values are 0 (STRING), 1 (REAL), 2 (INTEGER), 3 (ROW), or 4 (DECIMAL). The mysql.func system table shows which loadable functions have been registered using CREATE FUNCTION: SELECT * FROM mysql.func; The func table has these columns: name ...
https://dev.mysql.com/doc/refman/5.7/en/locale-support.html
The lc_time_names value does not affect the result from FORMAT(), but this function takes an optional third parameter that enables a locale to be specified to be used for the result number's decimal point, thousands separator, and grouping between ... The locale indicated by the lc_time_names system variable controls the language used to display day and month names and ...
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/miscellaneous-functions.html
mysql> UPDATE t SET i = DEFAULT(i)+1 WHERE id < 100; FORMAT(X,D) Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result as a string. Hexadecimal numbers in address components are not permitted, as ...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 ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/5.7/en/myisampack.html
pre-space The number of decimal columns that are stored with leading spaces. When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
--binary-as-hex Command-Line Format --binary-as-hex Introduced 5.7.19 Type Boolean Default Value FALSE When this option is given, mysql displays binary data using hexadecimal notation (0xvalue). mysql supports the following options, which can be ...
https://dev.mysql.com/doc/refman/5.7/en/no-matching-rows.html
If you are comparing FLOAT or DOUBLE columns with numbers that have decimals, you cannot use equality (=) comparisons. If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find ...