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/replication-features-reserved-words.html
Replication can fail in such cases with Error 1064 You have an error in your SQL syntax..., even if a database or table named using the reserved word or a table having a column named using the reserved word is excluded from replication. This is due ...In any SQL statements using these database object names, write the names as quoted identifiers using backtick characters ... You can encounter problems when you attempt to replicate from an older source to a newer ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-row-searches.html
When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching rows. If no matching record is found, it returns the error ER_KEY_NOT_FOUND and stops the replication ...The ...
https://dev.mysql.com/doc/refman/8.0/en/row-subqueries.html
An error occurs if the subquery produces multiple rows because a row subquery can return at most one row. The row constructor and the row returned by the subquery must contain the same number of values. Thus, the following query fails with a syntax ...If this row has col3 and col4 values equal to the col1 and col2 values of any rows in t1, the WHERE expression is TRUE and each query returns those t1 ...
https://dev.mysql.com/doc/refman/8.0/en/set-role.html
The server writes warnings to its error log for default roles that cannot be activated, but the client receives no warnings. If a user executes SET ROLE DEFAULT during a session, an error occurs if any default role cannot be activated (for example, ...} SET ROLE modifies the current user's effective privileges within the current session by specifying which of its granted roles are ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-usage.html
When binary log events were written in row-based format and you want to read or recover from a replication or database failure you can use this command to read contents of the binary log. When the system variable replica_exec_mode or slave_exec_mode ...The type of binary log used impacts the size and efficiency of ... MySQL uses ...
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: ...