PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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-config.html
--connect-string Command-Line Format --connect-string=connection_string Type String Default Value [none] Same as --ndb-connectstring. --defaults-extra-file Command-Line Format --defaults-extra-file=path Type String Default Value [none] Read given ...
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 Type String Default Value [none] When used together with --restore-data, this option applies a function to the value of the indicated column. --connect, -c Command-Line ...
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/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/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 ...