Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-auto-increment.html
The instructions just given are subject to the limitations of CREATE TABLE ... If a table definition includes any of those characteristics, create t2 using a CREATE TABLE statement that is identical to the one used to create t1, but with the ...(Bug ... Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated correctly using statement-based ...
https://dev.mysql.com/doc/workbench/en/wb-eer-color-key.html
Color connection lines within EER diagrams provide quick visual information about how the tables in your model relate. The following table defines the meaning of each color and indicates how you can open the underlying table information from your ...Existing connection lines are highlighted when you use a pointer device to hover on different database ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-configuration-properties.html
The properties are listed by categories in the following tables and then in the subsections that follow. Click on a property name in the tables to see its full description in the subsections. Configuration properties define how Connector/J will ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html
The properties are listed by categories in the following tables and then in the subsections that follow. Click on a property name in the tables to see its full description in the subsections. Configuration properties define how Connector/J will ...
https://dev.mysql.com/doc/refman/8.4/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...
https://dev.mysql.com/doc/refman/8.4/en/intersect.html
query_expression_body INTERSECT [ALL | DISTINCT] query_expression_body [INTERSECT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” INTERSECT limits the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The setup_consumers table contains the following hierarchy of values: global_instrumentation thread_instrumentation events_waits_current ...The ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Are stored procedures and functions created on a replication source server replicated to a replica? A.4.24. You can manage stored procedures with CREATE [FUNCTION|PROCEDURE], ALTER [FUNCTION|PROCEDURE], DROP [FUNCTION|PROCEDURE], and SHOW CREATE ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. OutputTableName: the name of the table where you want to create a new column to ...
https://dev.mysql.com/doc/refman/8.4/en/temporary-files.html
For some statements, MySQL creates temporary SQL tables that are not hidden and have names that begin with #sql. Some SELECT queries creates temporary SQL tables to hold intermediate results. DDL operations that rebuild the table and are not ...The ... On Unix, MySQL uses the value of the TMPDIR environment variable as the path name of the directory in which to store temporary ...