Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-table-select.html
This topic describes how to create a new table and insert data using a SELECT query. SELECT statement is executed, the SELECT query is offloaded to MySQL HeatWave for processing, while the table is created in the DB System. 1 row in set, 1 warning ...row *************************** id: 1 select_type: NONE table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL filtered: NULL Extra: Using secondary engine ...
https://dev.mysql.com/doc/workbench/en/wb-create-new-table.html
Create a new table by double-clicking the Add Table icon in the Physical Schemas panel, as the next figure shows. Figure 9.33 Model: Creating A New Table Initially, the table name defaults to 'table1' in the table editor. This action opens the ...
https://dev.mysql.com/doc/refman/8.4/en/creating-many-tables.html
If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-create-table-select.html
If the TEMPORARY keyword is not used, write CREATE TABLE (without select) + BEGIN + row events + COMMIT to the TC. (R-log-create-select-statement-format) If logging in statement format (that is, one of the following holds: (1) ...If there is an ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create.html
To create a FEDERATED table you should follow these steps: Create the table on the remote server. Alternatively, make a note of the table definition of an existing table, perhaps using the SHOW CREATE TABLE statement. Create the table on the local ...Note You can improve the performance of a FEDERATED table by adding indexes to the table on the ...The optimization occurs because the query sent to the remote server ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-auto-parallel-load.html
This topics in this section describe how to create external tables using Auto Parallel Load.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-manually.html
The topics in this section describe how to create external tables manually.
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
The SELECT statement can use a VALUES statement as its source, or can be replaced with a TABLE statement, as with CREATE TABLE ... The view definition is “frozen” at creation time and is not affected by subsequent changes to the definitions of ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...For information ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-select.html
ROW format: The statement is logged as a CREATE TABLE statement followed by a series of insert-row events. SELECT statement to make any changes in tables other than the table that is created by the statement. If the destination table does not exist, ...SELECT always performs an implicit commit (Section 15.3.3, “Statements That Cause an Implicit ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) ...The CONNECTION string contains the information required to connect to the remote server containing the table in which the data physically ...The format of the ...