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/string-functions.html
For functions that operate on string positions, the first position is numbered 1. If the first argument is a constant string and the second is a column of type SET, the FIND_IN_SET() function is optimized to use bit arithmetic. mysql> SELECT ...For ...mysql> SELECT CHAR(77,121,83,81,'76'); -> 'MySQL' mysql> SELECT CHAR(77,77.3,'77.3'); -> 'MMM' CHAR() arguments larger than 255 are converted into multiple result ...
https://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html
Table 12.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...A ...
https://dev.mysql.com/doc/refman/5.7/en/string-literals.html
See the description of the LIKE operator in Section 12.8.1, “String Comparison Functions and Operators”. You can do this in two ways: Process the string with a function that escapes the special characters. In a C program, you can use the ... A ...It has a character set other than binary and a collation that is compatible with the character ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-connection-strings.html
With the exception of the NDB Cluster management server (ndb_mgmd), each node that is part of an NDB Cluster requires a connection string that points to the management server's location. This connection string is used in establishing a connection ...This port should always be available on the network because it has been assigned by IANA for this purpose (see http://www.iana.org/assignments/port-numbers for ...
https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. For definitions of character ...
https://dev.mysql.com/doc/refman/5.7/en/string-collating.html
If the sorting rules for your language are too complex to be handled with simple arrays, you must define string collating functions in the ctype-MYSET.c source file in the strings directory. The existing character sets provide the best documentation ... For a simple character set named MYSET, sorting rules are specified in the MYSET.xml configuration file using <map> array elements within <collation> ...
https://dev.mysql.com/doc/refman/5.7/en/string-types.html
For descriptions of functions that operate on string values, see Section 12.8, “String Functions and Operators”. The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
Some encryption functions return strings of ASCII characters: MD5(), PASSWORD(), SHA(), SHA1(), SHA2(). If an application stores values from a function such as MD5() or SHA1() that returns a string of hex digits, more efficient storage and ...If you ...N is 16 for an MD5() value and 20 for a SHA1() ...
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 ...For example, UPPER(X) returns a string with the same character string and collation ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-functions.html
This occurs, for example, if a function does not support a specified algorithm, a key length is too short or long, or a string expected to be a key string in PEM format is not a valid key. MySQL Enterprise Encryption functions have these general ...