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/select-into.html
SELECT id, data INTO @x, @y FROM test.t1 LIMIT 1; INTO var_list can also be used with a TABLE statement, subject to these restrictions: The number of variables must match the number of columns in the table. If the table contains more than one row, ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-and-mysql-replication.html
For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica. Cascading actions for InnoDB tables on the source are executed on the replica only if the tables sharing the foreign key relation use ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_digest_lost The number of digest instances ...This can be nonzero if the value of performance_schema_digests_size is too ...
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
Table 8.27 Plugin and Library Names for FIDO Authentication Plugin or File Plugin or File Name Server-side plugin authentication_fido Client-side plugin authentication_fido_client Library file authentication_fido.so, authentication_fido_client.so ...
https://dev.mysql.com/doc/refman/8.0/en/concurrent-inserts.html
This is done to ensure that you can re-create an exact copy of your tables by applying the log during a backup operation. If the variable is set to ALWAYS (or 2), concurrent inserts at the end of the table are permitted even for tables that have ...
https://dev.mysql.com/doc/refman/8.0/en/explain-extended.html
For results consisting of multiple values, a temporary table may be created and <temporary table> is shown instead. <temporary table> This represents an internal temporary table created to cache an intermediate result. The Message value in SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-general-options.html
The options described in this section can be used for any type of table maintenance operation performed by myisamchk. The sections following this one describe options that pertain only to specific operations, such as table checking or repairing.
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html
Channel specific replication filters are particularly useful in a multi-source replication topology when the same database or table is present on multiple sources, and the replica is only required to replicate it from one source. Overview of ...
https://dev.mysql.com/doc/refman/8.0/en/handler-scope.html
However, SQLSTATE handlers take precedence over SQLEXCEPTION handlers, so if the table t is nonexistent, the DROP TABLE statement raises a condition that activates the SQLSTATE handler: mysql> CALL p1(); +--------------------------------+ | msg | ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. This is done to ensure that you can re-create an exact copy of your tables by applying the log during a backup operation. The number increases each time the server creates a new log file, thus creating an ordered series of ...It also contains events for statements that ...