MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 21 to 30 of 35 total results

12.17.2 Functions That Create JSON Values

https://dev.mysql.com/doc/refman/5.7/en/json-creation-functions.html

The functions listed in this section compose JSON values from component elements. JSON_ARRAY([val[, val] ...]) Evaluates a (possibly empty) list of values and returns a JSON array containing those values. mysql> SELECT JSON_ARRAY(1, "abc", NULL, ...

9.1.5 Bit-Value Literals

https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html

A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...

13.2.6 LOAD DATA Statement

https://dev.mysql.com/doc/refman/5.7/en/load-data.html

The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given. INTO Statement”.) To write data from a table to a file, use SELECT ... To read the file back into a table, use LOAD DATA. The syntax of ...

13.8.3 HELP Statement

https://dev.mysql.com/doc/refman/5.7/en/help.html

HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.14, ...

12.8.3 Character Set and Collation of Function Results

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 ...

12.21.3 Expression Handling

https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html

With precision math, exact-value numbers are used as given whenever possible. For example, numbers in comparisons are used exactly as given without a change in value. In strict SQL mode, for INSERT into a column with an exact data type (DECIMAL or ...

11.1.1 Numeric Data Type Syntax

https://dev.mysql.com/doc/refman/5.7/en/numeric-type-syntax.html

For integer data types, M indicates the minimum display width. Display width is unrelated to the range of values a type can store, as described in Section 11.1.6, “Numeric Type Attributes”. For floating-point and fixed-point data types, M is ...

12.4 Operators

https://dev.mysql.com/doc/refman/5.7/en/non-typed-operators.html

->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). 5.7.13 / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in ...

14.21.5 Writing Applications for the InnoDB memcached Plugin

https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-developing.html

You can perform the conversion on the application side, or by using the CAST() function in queries. Typically, writing an application for the InnoDB memcached plugin involves some degree of rewriting or adapting existing code that uses MySQL or the ...

9.2.5 Function Name Parsing and Resolution

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 ...

Displaying 21 to 30 of 35 total results