PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 11.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...
https://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html
The output from EXPLAIN shows ALL in the type column when MySQL uses a full table scan to resolve a query. There are no usable restrictions in the ON or WHERE clause for indexed columns. You are comparing indexed columns with constant values and ...
https://dev.mysql.com/doc/refman/5.7/en/where-optimization.html
If all columns in ORDER BY and GROUP BY clauses come from the same table, that table is preferred first when joining. If there is an ORDER BY clause and a different GROUP BY clause, or if the ORDER BY or GROUP BY contains columns from tables other ... This section discusses optimizations that can be made for processing WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' format in which account names are written in SQL statements. Its value is constructed from the User and Host columns of the user ... Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
As of MySQL 5.7.23, for new MySQL installations, the USER and HOST columns in the audit_log_user table used by MySQL Enterprise Audit have definitions that better correspond to the definitions of the User and Host columns in the mysql.user system ...
https://dev.mysql.com/doc/refman/5.7/en/bit-type.html
If you assign a value to a BIT(M) column that is less than M bits long, the value is padded on the left with zeros. For example, assigning a value of b'101' to a BIT(6) column is, in effect, the same as assigning b'000101'. The maximum combined size ... The BIT data type is used to store bit ...
https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html
This means that if you search with col_name LIKE 'a%', you get all column values that start with A or a. For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-coercibility.html
For example, in the following cases, it should be clear that the collation is the collation of column x: SELECT x FROM T ORDER BY x; SELECT x FROM T WHERE x = x; SELECT DISTINCT x FROM T; However, with multiple operands, there can be ambiguity. For ... 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/charset-table.html
The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name]] ALTER TABLE tbl_name ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf16.html
For example, since U+F8FF is the Apple Logo, this is legal: INSERT INTO t (utf16_column)VALUES (0xf8ff); /* legal */ Such characters cannot be expected to mean the same thing to everyone. Because MySQL must allow for the worst case (that one ... The ...