Search Results
https://dev.mysql.com/doc/refman/8.4/en/table.html
With INSERT and REPLACE statements, where you would otherwise use SELECT *. TABLE is a DML statement which returns rows and columns of the named table. Given the existence of a table named t, the following two statements produce identical output: ...
https://dev.mysql.com/doc/refman/8.4/en/thread-commands.html
A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Connect Used by replication receiver threads connected to the source, and by replication ...
https://dev.mysql.com/doc/refman/8.4/en/traceable-statements.html
Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...For statements which are prepared and executed in separate steps, preparation and execution are traced ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
You can declare an auto-increment column so that ascending values are filled in automatically as rows are inserted: # The value of ID can act like a pointer between related items in different tables. InnoDB tables are created using the CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
Immediately preceding SELECT for statements that include a SELECT statement: INSERT ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that ...
https://dev.mysql.com/doc/refman/8.4/en/working-with-null.html
A common error when working with NULL is to assume that it is not possible to insert a zero or an empty string into a column defined as NOT NULL, but this is not the case. The NULL value can be surprising until you get used to it. Conceptually, ...
https://dev.mysql.com/doc/refman/8.4/en/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-2-0.html
(WL #12429) Bugs Fixed Performance: records_in_range performed an excessive number of disk reads for insert operations. (Bug #34940000) Some inserts on tables with triggers were not always handled correctly. (Bug #35611072) Authentication Notes The ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
(Bug #35854919) Executing mysqldump on a replica would insert the FLUSH TABLES operation, an operation that writes to the binary log. Now FLUSH LOCAL TABLES is inserted instead to prevent GTID related issues during replication due to these binary ...