MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 41 to 50 of 59 total results

12.8.3 Character Set and Collation of Function Results

https://dev.mysql.com/doc/refman/5.7/en/string-functions-charset.html

The same applies for UNION, ||, CONCAT(), ELT(), GREATEST(), IF(), and LEAST(). 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 ...

26.4.4.23 The ps_trace_thread() Procedure

https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-thread.html

Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...

9.4 User-Defined Variables

https://dev.mysql.com/doc/refman/5.7/en/user-variables.html

You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...

13.7.5.9 SHOW CREATE PROCEDURE Statement

https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html

row *************************** Function: hello sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Create Function: CREATE DEFINER=`me`@`localhost` ... SHOW CREATE PROCEDURE proc_name This statement is a MySQL ...

5.1.7 Server System Variables

https://dev.mysql.com/doc/refman/5.7/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 Type Integer Default Value 1024 Minimum Value 4 Maximum Value (64-bit platforms) 18446744073709551615 Maximum ...

12.19.1 Aggregate Function Descriptions

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

In standard SQL, you would have to do a concatenation of all expressions inside COUNT(DISTINCT ...). 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 ... This section describes aggregate functions that operate on sets of ...

16.4.1.16 Replication of Invoked Features

https://dev.mysql.com/doc/refman/5.7/en/replication-features-invoked.html

If you rename the events, then when demoting this server back to being a replica, you can identify the events by querying the EVENTS table, as shown here: SELECT CONCAT(EVENT_SCHEMA, '.', EVENT_NAME) AS 'Db.Event' FROM INFORMATION_SCHEMA.EVENTS ...

B.3.4.3 Problems with NULL Values

https://dev.mysql.com/doc/refman/5.7/en/problems-with-null.html

All columns in the following example return NULL: mysql> SELECT NULL, 1+NULL, CONCAT('Invisible',NULL); To search for column values that are NULL, you cannot use an expr = NULL test. The concept of the NULL value is a common source of confusion for ...

21.5.17 ndb_perror — Obtain NDB Error Message Information

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-perror.html

ndb_perror shows information about an NDB error, given its error code. This includes the error message, the type of error, and whether the error is permanent or temporary. Added to the MySQL NDB Cluster distribution in NDB 7.6, it is intended as a ...

21.6.13 Distributed Privileges Using Shared Grant Tables

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-privilege-distribution.html

To verify that the conversion was successful, you can use the stored function mysql_cluster_privileges_are_distributed as shown here: mysql> SELECT CONCAT( -> 'Conversion ', -> IF(mysql.mysql_cluster_privileges_are_distributed(), 'succeeded', ...

Displaying 41 to 50 of 59 total results