PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
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/function-resolution.html
ADDDATE BIT_AND BIT_OR BIT_XOR CAST COUNT CURDATE CURTIME DATE_ADD DATE_SUB EXTRACT GROUP_CONCAT MAX MID MIN NOW POSITION SESSION_USER STD STDDEV STDDEV_POP STDDEV_SAMP SUBDATE SUBSTR SUBSTRING SUM SYSDATE SYSTEM_USER TRIM VARIANCE VAR_POP VAR_SAMP ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-general-purpose.html
As of MySQL 5.7.13, MySQL Server includes an SQL interface for keyring key management, implemented as a set of general-purpose functions that access the capabilities provided by the internal keyring service. The keyring functions are contained in a ... MySQL Server supports a keyring service that enables internal server components and plugins to store sensitive information securely for later ...
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/date-and-time-functions.html
CURDATE() Returns the current date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in string or numeric context. CURTIME([fsp]) Returns the current time as a value in 'hh:mm:ss' or hhmmss format, depending on ... This section describes the functions that can be used to manipulate temporal ...See Section 11.2, “Date and Time Data Types”, for a description of the range of ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
However, if logging occurs at the statement level, there are certain binary logging issues with respect to stored programs (stored procedures and functions, triggers, and events): In some cases, a statement might affect different sets of rows on ...
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/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-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 ...