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/charset-literal.html
Every character string literal has a character set and a collation. For the simple statement SELECT 'string', the string has the connection default character set and collation defined by the character_set_connection and collation_connection system ...Examples: SELECT 'abc'; SELECT _latin1'abc'; SELECT _binary'abc'; SELECT _utf8'abc' COLLATE utf8_danish_ci; Character set introducers and the COLLATE clause are implemented according to standard SQL ...
https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...Simple comparison operations (>=, >, =, <, <=, sorting, and grouping) are based on each character's “sort value.” Characters with the same sort value are treated as the same ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions-charset.html
MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's ...If explicit COLLATE Y and COLLATE Z occur, raise an ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
To clear the SQL mode explicitly, set it to an empty string using --sql-mode="" on the command line, or sql-mode="" in an option file. ANSI_QUOTES Treat " as an identifier quote character (like the ` quote character) and not as a string quote ...
https://dev.mysql.com/doc/refman/5.7/en/replace-utility.html
The replace utility program changes strings in place in files or on the standard input. < file_name from represents a string to look for and to represents its replacement. Use the -- option to indicate where the string-replacement list ends and the ...Note The replace utility is deprecated as of MySQL 5.7.18 and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-character.html
For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when you do not need language-specific collation features. When comparing values from different columns, declare those ...
https://dev.mysql.com/doc/refman/5.7/en/gis-polygon-property-functions.html
If the argument is NULL or an empty geometry, the return value is NULL. Such components are extracted and made into a single MultiPolygon, MultiLineString, or MultiPoint for centroid computation. If the argument is an empty geometry collection, the ... Functions in this section return properties of Polygon or MultiPolygon ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html
These rows have the country and products columns set to NULL. This row has the year, country, and products columns set to NULL. The NULL indicators in each super-aggregate row are produced when the row is sent to the client. For any column in the ...
https://dev.mysql.com/doc/refman/5.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. (There is an existing SQL function Length() that calculates the length of string values.) GLength() is deprecated; expect it to be ...EndPoint() is deprecated; expect it to be removed in a future MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-failover.html
There are a number of techniques when using MySQL Replication with Global Transaction Identifiers (GTIDs) for provisioning a new replica which can then be used for scaleout, being promoted to source as necessary for failover. Each identifier ...