Search Results
https://dev.mysql.com/doc/refman/9.7/en/aggregate-functions.html
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. This section describes aggregate functions that operate on sets of values. They are often used with a GROUP ...
https://dev.mysql.com/doc/refman/9.7/en/alter-procedure.html
This behavior can be changed by disabling the automatic_sp_privileges system variable. More than one change may be specified in an ALTER PROCEDURE statement. However, you cannot change the parameters or body of a stored procedure using this ...
https://dev.mysql.com/doc/refman/9.7/en/arithmetic-functions.html
In division performed with /, the scale of the result when using two exact-value operands is the scale of the first operand plus the value of the div_precision_increment system variable (which is 4 by default). Table 14.9 Arithmetic Operators Name ...
https://dev.mysql.com/doc/refman/9.7/en/binary-log-mysql-database.html
Statements that affect mysql database tables are written to the binary log using the following rules: Data manipulation statements that change data in mysql database tables directly are logged according to the setting of the binlog_format system ...
https://dev.mysql.com/doc/refman/9.7/en/condition-filtering.html
To control whether the optimizer considers additional filtering conditions, use the condition_fanout_filter flag of the optimizer_switch system variable (see Section 10.9.2, “Switchable Optimizations”). In join processing, prefix rows are those ...
https://dev.mysql.com/doc/refman/9.7/en/create-role.html
When the read_only system variable is enabled, CREATE ROLE additionally requires the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege). CREATE ROLE [IF NOT EXISTS] role [, role ] ... CREATE ROLE creates one or more roles, which are ...
https://dev.mysql.com/doc/refman/9.7/en/deallocate-prepare.html
If too many prepared statements are created and not deallocated by either the DEALLOCATE PREPARE statement or the end of the session, you might encounter the upper limit enforced by the max_prepared_stmt_count system variable. {DEALLOCATE | DROP} ...
https://dev.mysql.com/doc/refman/9.7/en/deleting-from-related-tables.html
If the total length of the DELETE statement for related_table is more than the default value of the max_allowed_packet system variable, you should split it into smaller parts and execute multiple DELETE statements. You probably get the fastest ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-single-consensus-leader.html
By default, the group communication engine for Group Replication (XCom, a Paxos variant) operates using every member of the replication group as a leader. The group communication engine can use a single leader to drive consensus when the group is ...
https://dev.mysql.com/doc/refman/9.7/en/index-extensions.html
InnoDB automatically extends each secondary index by appending the primary key columns to it. Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX ...