PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/miscellaneous-functions.html
The return value is a string of five hexadecimal numbers separated by dashes. 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 ...The ...
https://dev.mysql.com/doc/refman/9.7/en/environment-variables.html
For example, setting UMASK=0600 is equivalent to UMASK=384 because 0600 octal is 384 decimal. This section lists environment variables that are used directly or indirectly by MySQL. Most of these can also be found in other places in this manual.
https://dev.mysql.com/doc/refman/9.7/en/examples.html
Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/doc/refman/9.7/en/file-permissions.html
For example, setting UMASK=0600 is equivalent to UMASK=384 because 0600 octal is 384 decimal. If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld starts. For example, mysqld ...
https://dev.mysql.com/doc/refman/9.7/en/floating-point-types.html
Here, (M,D) means than values can be stored with up to M digits in total, of which D digits may be after the decimal point. The FLOAT and DOUBLE types represent approximate numeric data values. MySQL uses four bytes for single-precision values and ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-columns-table.html
1 = VARCHAR, 2 = CHAR, 3 = FIXBINARY, 4 = BINARY, 5 = BLOB, 6 = INT, 7 = SYS_CHILD, 8 = SYS, 9 = FLOAT, 10 = DOUBLE, 11 = DECIMAL, 12 = VARMYSQL, 13 = MYSQL, 14 = GEOMETRY. For related usage information and examples, see Section 17.15.3, “InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-fulltext-index.html
For example, in the auxiliary table name test/fts_0000000000000147_00000000000001c9_index_1, the hex value 1c9 has a decimal value of 457. Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-system-tables.html
MB values are rounded to zero decimal spaces using the ROUND() function. You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get this type of information using the ...
https://dev.mysql.com/doc/refman/9.7/en/jdv-examples.html
CREATE TABLE customers ( customer_id INT PRIMARY KEY, name VARCHAR(100) ); CREATE TABLE orders ( order_id INT PRIMARY KEY, customer_id INT, product VARCHAR(100), amount DECIMAL(10,2), FOREIGN KEY (customer_id) REFERENCES customers(customer_id) ); ...
https://dev.mysql.com/doc/refman/9.7/en/json-duality-views-syntax.html
The CREATE JSON RELATIONAL DUALITY VIEW statement is an extension of the CREATE VIEW statement. There are some additional clauses with CREATE JSON RELATIONAL DUALITY VIEW, and some restrictions on the SELECT statement. The result set is structured ...