PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-repertoire.html
Consider the following CONCAT() calls: CONCAT(_ucs2 X'0041', _ucs2 X'0042') CONCAT(_ucs2 X'0041', _ucs2 X'00C2') For the first call, the repertoire is ASCII because both arguments are within the ASCII range. The repertoire of a character set is the ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
CONCAT_WS(separator,str1,str2,...) CONCAT_WS() stands for Concatenate With Separator and is a special form of CONCAT(). mysql> SELECT CONCAT_WS(',', 'First name', 'Second name', 'Last Name'); -> 'First name,Second name,Last Name' mysql> SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/char.html
The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. They also differ in maximum length and in whether trailing spaces are retained. The CHAR and VARCHAR types are declared with a length that indicates the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
CREATE FUNCTION GTID_SYMMETRIC_DIFFERENCE(gs1 LONGTEXT, gs2 LONGTEXT) RETURNS LONGTEXT RETURN GTID_SUBTRACT(CONCAT(gs1, ',', gs2), GTID_INTERSECTION(gs1, gs2)) | This function removes from a GTID set all the GTIDs with the specified origin, and ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-coercibility.html
For example, a multiple-argument concatenation operation such as CONCAT(x,'Y') combines its arguments to produce a single string. The concatenation of two strings with different collations has a coercibility of 1. For example, the following ... In ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
MySQL 5.7 supports explicit selection of partitions and subpartitions that, when executing a statement, should be checked for rows matching a given WHERE condition. Partition selection is similar to partition pruning, in that only specific ...
https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
mysql> SELECT 1+'1'; -> 2 mysql> SELECT CONCAT(2,' test'); -> '2 test' It is also possible to convert a number to a string explicitly using the CAST() function. Conversion occurs implicitly with the CONCAT() function because it expects string ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
Values of a generated column are computed from an expression included in the column definition. Generated columns are supported by the NDB storage engine beginning with MySQL NDB Cluster 7.5.3. Generated column definitions have this syntax: col_name ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
Make sure that the column is sorted lexically rather than by index number by coding ORDER BY CAST(col AS CHAR) or ORDER BY CONCAT(col). For example, this CREATE TABLE statement does not work because the CONCAT function cannot be used to construct an ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
Because of this nice syntax, MySQL Server does not support the standard SQL || operator for string concatenation; use CONCAT() instead. Because CONCAT() takes any number of arguments, it is easy to convert use of the || operator to MySQL Server.