Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-collections-operations.html
In MySQL Shell, you can create new collections, get a list of the existing collections in a schema, and remove an existing collection from a schema. The following example creates a collection called flags in the world_x schema. Collection names are ...
https://dev.mysql.com/doc/refman/8.4/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
For example, this might be a file created by issuing the command mysqldump --no-data. MySQL Workbench handles the script as follows: If the script does not contain a CREATE DATABASE db_name; statement, the schema objects are copied to the initial ...
https://dev.mysql.com/doc/workbench/en/wb-vertical-toolbar.html
Change to the standard mouse pointer tool and pick up any objects you would like to place on the newly created layer. For more information about text objects, see Section 9.1.9, “Creating Text Objects”. 9.1.2.2.7 The Table Tool Use this tool to ... The vertical toolbar appears on the left sidebar (see the following figure) when an EER diagram tab is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-rag.html
The examples in this topic use the vector store table demo_embeddings created in the section Ingesting Files Using the URI with Asynchronous Load. In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires ... The ML_RAG routine runs retrieval-augmented generation which aims to generate more accurate responses for your ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
This clause always begins with PARTITION BY, and follows the same syntax and other rules as apply to the partition_options clause for CREATE TABLE (for more detailed information, see Section 15.1.20, “CREATE TABLE Statement”), and can also be ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
Supported table DDL statements include CREATE, ALTER, and DROP statements for databases, tablespaces, tables, and indexes, and the TRUNCATE TABLE statement. Supported non-table DDL statements include: CREATE and DROP statements, and, if applicable, ...An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
Use this option if you do not want to remove existing user-created data (schemas, tables, tablespaces) and binary logs from the recipient data directory. The MySQL server must have the necessary write access to create the directory. When the ... The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-files-table.html
For NDB: The name of an undo log file created by CREATE LOGFILE GROUP or ALTER LOGFILE GROUP, or of a data file created by CREATE TABLESPACE or ALTER TABLESPACE. This means, for example, that the name of a data file created with ALTER TABLESPACE ts ... The FILES table provides information about the files in which MySQL tablespace data is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
Session Temporary Tablespaces Session temporary tablespaces store user-created temporary tables and internal temporary tables created by the optimizer when InnoDB is configured as the storage engine for on-disk internal temporary tables. Session ...