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/entering-queries.html
Make sure that you are connected to the server, as discussed in the previous section. Doing so does not in itself select any database to work with, but that is okay. At this point, it is more important to find out a little about how to issue ...
https://dev.mysql.com/doc/refman/9.7/en/exists-and-not-exists-subqueries.html
If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For example: SELECT column1 FROM t1 WHERE EXISTS (SELECT * FROM t2); Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-cjk.html
This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) issues. What problems should I be aware of when working with the Big5 ...
https://dev.mysql.com/doc/refman/9.7/en/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. This section describes some ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-natural-language.html
| 1.3114095926285 | +----+-------------------------------------+-----------------+ 2 rows in set (0.00 sec) A phrase that is enclosed within double quote (") characters matches only rows that contain the phrase literally, as it was typed. By ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-search.html
There are no special operators, with the exception of double quote (") characters. MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE ...
https://dev.mysql.com/doc/refman/9.7/en/gis-class-geometry.html
Its coordinates in its spatial reference system, represented as double-precision (8-byte) numbers. It is a noninstantiable class but has a number of properties, described in the following list, that are common to all geometry values created from any ...
https://dev.mysql.com/doc/refman/9.7/en/gis-linestring-property-functions.html
You can extract particular points of a LineString, count the number of points that it contains, or obtain its length. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any ...
https://dev.mysql.com/doc/refman/9.7/en/gis-polygon-property-functions.html
These functions are available for obtaining polygon properties: ST_Area({poly|mpoly}) Returns a double-precision number indicating the area of the Polygon or MultiPolygon argument, as measured in its spatial reference system. Functions in this ...
https://dev.mysql.com/doc/refman/9.7/en/identifier-mapping.html
There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each database as a directory in the data directory, and depending upon the storage engine, each table may be ...