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/aggregate-functions-and-modifiers.html
They are often used with a GROUP BY clause to group values into subsets.
https://dev.mysql.com/doc/refman/5.7/en/gis-geometrycollection-property-functions.html
mysql> SET @gc = 'GeometryCollection(Point(1 1),LineString(2 2, 3 3))'; mysql> SELECT ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)); +-------------------------------------------------+ | ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)) | ...
https://dev.mysql.com/doc/refman/5.7/en/gis-point-property-functions.html
A Point consists of X and Y coordinates, which may be obtained using the following functions: ST_X(p) Returns the X-coordinate value for the Point object p as a double-precision number. mysql> SELECT ST_X(Point(56.7, 53.34)); ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-functions.html
Table 12.8 Numeric Functions and Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator ABS() Return the absolute value ACOS() Return ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-functions.html
The following sections describe sys schema stored functions. ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
--remap-column=db.tbl.col:fn:args Command-Line Format --remap-column=string Introduced 5.7.29-ndb-7.6.14 Type String Default Value [none] When used together with --restore-data, this option applies a function to the value of the indicated column.
https://dev.mysql.com/doc/refman/5.7/en/json.html
(For strings in the ascii or utf8 character sets, no conversion is needed because ascii and utf8 are subsets of utf8mb4.) As an alternative to writing JSON values using literal strings, functions exist for composing JSON values from component ...The ...JSON documents stored in JSON columns are converted to an internal format that permits quick read access to document ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html
Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string containing an SQL statement or a file containing statements. --create=value Command-Line Format --create=value Type String The ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
Strings are automatically converted to numbers and numbers to strings as necessary. Some of the functions in this section return values other than 1 (TRUE), 0 (FALSE), or NULL. LEAST() and GREATEST() are examples of such functions; Section 12.3, ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
Input File Character Set The file name must be given as a literal string. If you specify no FIELDS or LINES clause, the defaults are the same as if you had written this: FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY ...