Search Results
https://dev.mysql.com/doc/refman/8.4/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. In addition, you can work in SQL with results from queries on tables in the INFORMATION_SCHEMA database, which you cannot easily ...The pattern is useful for restricting statement output to matching ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-errors.html
All of the errors described in this section also apply when using TABLE in subqueries. Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 row" This error occurs for ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
Only statements that modify databases or tables count against the update limit. An “account” in this context corresponds to a row in the mysql.user system table. That is, a connection is assessed against the User and Host values in the user ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/index.html
Abstract This is the user manual for MySQL Enterprise Backup, a commercially licensed backup utility for MySQL databases. It explains the different kinds of backup and restore that can be performed with MySQL Enterprise Backup, and describes the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-faq.html
This file represents the InnoDB system tablespace, which grows but never shrinks as a database server operates, and is included in every full and incremental backup. The ibdata1 file in the incremental backups is typically much smaller, containing ... This section lists some common questions about MySQL Enterprise Backup, with answers and pointers to further ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-myisam.html
mysqlbackup also backs up the .MYD files, .MYI files, and the .sdi files associated with the MyISAM tables. Files with other extensions that are backed up are shown in Table 1.1, “Types of Files in a Backup”. Note While MySQL Enterprise Backup ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-read-write-splitting-statements.html
The following describes read-only statements: Statements are read-only if they start with: SELECT DO VALUES TABLE WITH that is not followed by UPDATE or DELETE. The following DML: CALL, INSERT, UPDATE, DELETE, REPLACE, IMPORT TABLE, LOAD DATA, LOAD ...EXPLAIN, DESCRIBE, or DESC which are not followed by UPDATE or ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-json.html
MySQL Shell's JSON import utility util.importJSON() enables you to import JSON documents from a file (or FIFO special file) or standard input to a MySQL Server collection or relational table. You can import the JSON documents to an existing table ...The utility checks that the supplied JSON documents are well-formed and inserts them into the target database, removing the need to use multiple INSERT statements or write scripts to achieve this ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-model-catalog.html
The MODEL_CATALOG table is created in a schema named ML_SCHEMA_user_name, where the user_name is the name of the owning user. The fully qualified name of the model catalog table is ML_SCHEMA_user_name.MODEL_CATALOG. When a user creates a model, the ...AutoML creates a model catalog for any user that creates a machine learning ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-models-delete.html
Users that create models or have the required privileges to a model on the MODEL_CATALOG table can delete them. Delete a Model To delete a model from the model catalog table: Query the model catalog table for the model_id, model_owner, and ...