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/string-functions.html
mysql> SELECT FIELD('Bb', 'Aa', 'Bb', 'Cc', 'Dd', 'Ff'); -> 2 mysql> SELECT FIELD('Gg', 'Aa', 'Bb', 'Cc', 'Dd', 'Ff'); -> 0 FIND_IN_SET(str,strlist) Returns a value in the range of 1 to N if the string str is in the string list strlist consisting of ...For functions that operate on string positions, the first position is ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
string_find(text, substr) Checks whether the substr value is contained in the text value. For information about using JSON data in MySQL, see Section 11.5, “The JSON Data Type”. Filter definitions have this form, where actions indicates how ...
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/mysql-cluster-ndb-api-statistics.html
You can obtain values for a particular set of variables by additionally filtering for the substring session, slave, or injector in the variable name (along with the common prefix Ndb_api). A number of types of statistical counters relating to ...
https://dev.mysql.com/doc/refman/5.7/en/xml-functions.html
Table 12.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-enum.html
For SET, the value is inserted as given except that any invalid substrings are deleted. ENUM and SET columns provide an efficient way to define columns that can contain only a given set of values. See Section 11.3.5, “The ENUM Type”, and ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
MySQL Server supports some extensions that are likely not to be found in other SQL DBMSs. Be warned that if you use them, your code is not portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the ...
https://dev.mysql.com/doc/refman/5.7/en/MySQLInstallerConsole.html
MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL Installer. This reference includes: MySQL Product Names Command Syntax Command Actions The console is installed when MySQL Installer is initially executed and ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
The second is similar, but not the same: It finds rows where set_col contains value anywhere, even as a substring of another set member. A SET is a string object that can have zero or more values, each of which must be chosen from a list of ...