MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 10 total results

https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html

GROUP_CONCAT(expr) This function returns a string result with the concatenated non-NULL values from a group. The result is truncated to the maximum length that is given by the group_concat_max_len system variable, which has a default value of 1024.

14.1 Built-In Function and Operator Reference

https://dev.mysql.com/doc/refman/8.0/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 14.2, “Loadable Function Reference”. ->> Return value ...

1.6.1 MySQL Extensions to Standard SQL

https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html

MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in ...

1.2.2 The Main Features of MySQL

https://dev.mysql.com/doc/refman/8.0/en/features.html

Support for group functions (COUNT(), AVG(), STD(), SUM(), MAX(), MIN(), and GROUP_CONCAT()). This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of ...

11.2.5 Function Name Parsing and Resolution

https://dev.mysql.com/doc/refman/8.0/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 ...

10.4.4 Internal Temporary Table Use in MySQL

https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html

In some cases, the server creates internal temporary tables while processing statements. The server creates temporary tables under conditions such as these: Evaluation of UNION statements, with some exceptions described later. Evaluation of some ...

13.5 The JSON Data Type

https://dev.mysql.com/doc/refman/8.0/en/json.html

Non-NULL values are converted to a numeric type and aggregated, except for MIN(), MAX(), and GROUP_CONCAT(). The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents ...

B.3.7 Known Issues in MySQL

https://dev.mysql.com/doc/refman/8.0/en/known-issues.html

DISTINCT with ORDER BY does not work inside GROUP_CONCAT() if you do not use all and only those columns that are in the DISTINCT list. This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see ...

7.1.8 Server System Variables

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html

group_concat_max_len Command-Line Format --group-concat-max-len=# System Variable group_concat_max_len Scope Global, Session Dynamic Yes SET_VAR Hint Applies Yes Type Integer Default Value 1024 Minimum Value 4 Maximum Value (64-bit platforms) ...

30.4.5.17 The ps_thread_trx_info() Function

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-trx-info.html

Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...

Displaying 10 total results