PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/account-names.html
The user name and host name parts, if quoted, must be quoted separately. MySQL stores account names in grant tables in the mysql system database using separate columns for the user name and host name parts: The user table contains one row for each ... MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different ...
https://dev.mysql.com/doc/refman/8.0/en/call.html
Metadata changes to objects referred to by stored programs are detected and cause automatic reparsing of the affected statements when the program is next executed. CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored ...CALL can pass back values to its caller using parameters that are declared as OUT or INOUT ...
https://dev.mysql.com/doc/refman/8.0/en/charset-introducer.html
collation_name must be a permitted collation for the connection default character set. A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a ...
https://dev.mysql.com/doc/refman/8.0/en/charset-literal.html
collation_name must be a permitted collation for the connection default character set. For the simple statement SELECT 'string', the string has the connection default character set and collation defined by the character_set_connection and ... Every ...
https://dev.mysql.com/doc/refman/8.0/en/comparisons-using-subqueries.html
It finds all rows in table t1 containing a value that occurs twice in a given column: SELECT * FROM t1 AS t WHERE 2 = (SELECT COUNT(*) FROM t1 WHERE t1.id = t.id); For a comparison of the subquery to a scalar, the subquery must return a scalar. For ... The most common use of a subquery is in the form: non_subquery_operand comparison_operator (subquery) Where comparison_operator is one of these operators: = > < >= <= <> != <=> For example: ...
https://dev.mysql.com/doc/refman/8.0/en/execute.html
If the prepared statement contains any parameter markers, you must supply a USING clause that lists user variables containing the values to be bound to the parameters. Parameter values can be supplied only by user variables, and the USING clause ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-mode.html
The following functions enable you to control the mode which a replication group is running in, either single-primary or multi-primary mode. Must be issued on a member of a replication group running in single-primary mode. Return value: A string ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-primary-mode.html
When deploying in single-primary mode, or changing the group to single-primary mode, this system variable must be set to OFF. Because all members must reach the same decision, members adapt their primary election algorithm if other group members are ... In single-primary mode (group_replication_single_primary_mode=ON) the group has a single primary server that is set to read/write ...
https://dev.mysql.com/doc/refman/8.0/en/if.html
[ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. Note There is also an IF() function, which differs from the IF statement described here. The IF statement can have THEN, ELSE, and ELSEIF ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-connection-control-failed-login-attempts-table.html
Notes The CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS plugin must be activated for this table to be available, and the CONNECTION_CONTROL plugin must be activated or the table contents are always empty. This table provides information about the ...