PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/gis-point-property-functions.html
These functions are available for obtaining point properties: ST_Latitude(p [, new_latitude_val]) With a single argument representing a valid Point object p that has a geographic spatial reference system (SRS), ST_Latitude() returns the latitude ...
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
The identifier quote character is the backtick (`): mysql> SELECT * FROM `select` WHERE `select`.id > 100; If the ANSI_QUOTES SQL mode is enabled, it is also permissible to quote identifiers within double quotation marks: mysql> CREATE TABLE "test" ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html
Quoting can be done with either single quote ('), double quote ("), or backtick (`) characters. For example: [mysql] prompt=(\\u@\\h) [\\d]>\\_ In this example, note that the backslashes are doubled. If you set the prompt using the prompt option in ... mysql sends each SQL statement that you issue to the server to be ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-types.html
These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, and DOUBLE PRECISION). MySQL treats DOUBLE as a synonym for DOUBLE PRECISION (a nonstandard ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
Consider these statements: mysql> CREATE TABLE t (i INT, d DECIMAL, f FLOAT); mysql> INSERT INTO t VALUES(1,1,1); mysql> CREATE TABLE y SELECT AVG(i), AVG(d), AVG(f) FROM t; The result is a double only for the floating-point argument. This section ...
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") characters. The following lines are equivalent: 'a string' 'a' ' ' 'string' If the ANSI_QUOTES SQL mode is enabled, string literals can be ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
For numeric arguments, the variance and standard deviation functions return a DOUBLE value. The SUM() and AVG() functions return a DECIMAL value for exact-value arguments (integer or DECIMAL), and a DOUBLE value for approximate-value arguments ...
https://dev.mysql.com/doc/refman/8.0/en/command-line-options.html
The capabilities of your command processor dictate your choices for whether you can use single or double quotation marks and the syntax for escaping quote characters. For example, if your command processor supports quoting with single or double ...
https://dev.mysql.com/doc/refman/8.0/en/constant-folding-optimization.html
If the constant is one of the decimal types (such as DECIMAL, REAL, DOUBLE, or FLOAT) and has a nonzero decimal portion, it cannot be equal; fold accordingly. FLOAT(m,n) or DOUBLE(m,n) values compared with constants are handled as follows: If the ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
Values of a generated column are computed from an expression included in the column definition. Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] ...