Search Results
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin.html
By default, a remote cloning operation removes existing user-created data (schemas, tables, tablespaces) and binary logs from the recipient data directory before cloning data from the donor. The clone plugin permits cloning data locally or from a ...
https://dev.mysql.com/doc/refman/8.4/en/comments.html
(Under some conditions, nested comments might be permitted, but usually are not, and users should avoid them.) MySQL Server supports certain variants of C-style comments. MySQL Server supports three comment styles: From a # character to the end of ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
In read-only mode, it remains possible to change tables created with the TEMPORARY keyword using DML statements. Rolling back can be a slow operation that may occur implicitly without the user having explicitly asked for it (for example, when an ...
https://dev.mysql.com/doc/refman/8.4/en/connectors-apis.html
Connector/NET enables developers to create .NET applications that connect to MySQL. Native drivers are also easier for end users to build and deploy because no copy of the MySQL client libraries is needed to build the native driver components.
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-transactional-storage.html
Data dictionary tables are created in a single InnoDB tablespace named mysql.ibd, which resides in the MySQL data directory. Dictionary data is protected by the same commit, rollback, and crash-recovery capabilities that protect user data that is ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
For example, the following statement finds rows matching the WHERE clause, sorts them by timestamp_column, and deletes the first (oldest) one: DELETE FROM somelog WHERE user = 'jcole' ORDER BY timestamp_column LIMIT 1; ORDER BY also helps to delete ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
For a query in which the condition is on the tables of a view created using ALGORITHM=TEMPTABLE instead of on the view itself, the multiple equality is not recognized at resolution, and thus the condition cannot be not pushed down. A condition ...
https://dev.mysql.com/doc/refman/8.4/en/document-store.html
For example, when you create documents describing products, you do not need to know and define all possible attributes of any products before storing and operating with the documents. See X DevAPI User Guide for in-depth tutorials on using X DevAPI.
https://dev.mysql.com/doc/refman/8.4/en/drop-procedure.html
(If the automatic_sp_privileges system variable is enabled, that privilege and EXECUTE are granted automatically to the routine creator when the routine is created and dropped from the creator when the routine is dropped. See Section 27.2.2, ...
https://dev.mysql.com/doc/refman/8.4/en/error-interfaces.html
SHOW ENGINE INNODB STATUS statement output includes information about the most recent foreign key error if a CREATE TABLE statement for an InnoDB table fails. The client may display the error message so the user can take corrective measures, ...