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-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/savepoint.html
SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL statements SAVEPOINT, ROLLBACK TO SAVEPOINT, RELEASE SAVEPOINT and the optional WORK keyword for ROLLBACK. Modifications that the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-miscellaneous-tables.html
The following sections describe tables that do not fall into the table categories discussed in the preceding sections: component_scheduler_tasks: The current status of each scheduled task. user_defined_functions: Loadable functions registered by a ...
https://dev.mysql.com/doc/refman/8.0/en/compiler-characteristics.html
In some cases, the compiler used to build MySQL affects the features available for use. The notes in this section apply for binary distributions provided by Oracle Corporation or that you compile yourself from source. icc (Intel C++ Compiler) ...
https://dev.mysql.com/doc/refman/8.0/en/charset-server.html
By default, these are utf8mb4 and utf8mb4_0900_ai_ci, but they can be set explicitly at server startup on the command line or in an option file and changed at runtime. The server character set and collation are used as default values if the database ...Initially, the server character set and collation depend on the options that you use when you start ...
https://dev.mysql.com/doc/refman/8.0/en/full-table.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. If a table-full error occurs, it may be that the disk is full or that the table has reached its ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-length.html
If the table name is close to the length limit for constraint names, the additional characters required for the constraint name may cause that name to exceed the limit, resulting in an error. This applies to identifiers in table definitions and to ... The following table describes the maximum length for each type of ...See Section ...
https://dev.mysql.com/doc/refman/8.0/en/invoking-programs.html
For example, the mysql program interprets the first nonoption argument as a database name, so the command mysql --user=root test indicates that you want to use the test database. Other connection options are --port (or -P) to specify a TCP/IP port ... To invoke a MySQL program from the command line (that is, from your shell or command prompt), enter the program name followed by any options or other arguments needed to instruct the program what you want it to ...