PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-optimization.html
If there is a row in A that matches the WHERE clause, but there is no row in B that matches the ON condition, an extra B row is generated with all columns set to NULL. For a LEFT JOIN, if the WHERE condition is always false for the generated NULL ...
https://dev.mysql.com/doc/refman/5.7/en/show-plugins.html
row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row *************************** Name: CSV Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
Not all storage engines update this time, in which case, the value is always NULL. For views, all columns displayed by SHOW TABLE STATUS are NULL except that Name indicates the view name and Comment says VIEW. SHOW TABLE STATUS [{FROM | IN} ...
https://dev.mysql.com/doc/refman/5.7/en/using-spatial-indexes.html
The following query finds all objects that are in the given rectangle: mysql> SET @poly = -> 'Polygon((30000 15000, 31000 15000, 31000 16000, 30000 16000, 30000 15000))'; mysql> SELECT fid,ST_AsText(g) FROM geom WHERE -> ... The optimizer ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
This can have values A (ascending), D (descending), or NULL (not sorted). That is, the number of indexed characters if the column is only partly indexed, NULL if the entire column is indexed. However, prefix lengths for index specifications in ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-coercibility.html
For example, this statement performs a comparison between the column x and the string literal 'Y': SELECT x FROM T WHERE x = 'Y'; If x and 'Y' have the same collation, there is no ambiguity about the collation to use for the comparison. For example, ... In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison ...
https://dev.mysql.com/doc/refman/5.7/en/gis-format-conversion-functions.html
There are also functions to convert a string from WKT or WKB format to internal geometry format. ST_AsText(g), ST_AsWKT(g) Converts a value in internal geometry format to its WKT representation and returns the string result. mysql> SET @g = ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
It makes SQL operations faster, by enabling better use of indexes and eliminating overhead for testing whether each value is NULL. If you really need NULL values in your tables, use them. Just avoid the default setting that allows NULL values in ...
https://dev.mysql.com/doc/refman/5.7/en/regexp.html
Table 12.14 Regular Expression Functions and Operators Name Description NOT REGEXP Negation of REGEXP REGEXP Whether string matches regular expression RLIKE Whether string matches regular expression A regular expression is a powerful way of ...This ...