Search Results
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-navigator.html
A new table with the imported fields is created in the selected schema, unless you select the append or update (overwrite) option. This also has a simpler and easier to use interface for analyzing and creating indexes for tables. Create Table: ...To ... The Navigator area of the sidebar contains options to manage the active MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
--initialize, -I Command-Line Format --initialize[={OFF|ON}] Type Boolean Default Value OFF This option is used to initialize a MySQL installation by creating the data directory and populating the tables in the mysql system schema. The server ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-usage.html
Compressed tables can be created in file-per-table tablespaces or in general tablespaces. The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed. You ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
However, even if explicitly referenced, a column that is invisible in the existing table is visible in the new table: mysql> CREATE TABLE t1 (col1 INT, col2 INT INVISIBLE); mysql> CREATE TABLE t2 AS SELECT col1, col2 FROM t1; mysql> SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
You must also remember to account for any column indexes as follows: Each primary key or hash index created for an NDBCLUSTER table requires 21−25 bytes per record. Creating NDB Cluster tables with USING HASH for all primary keys and unique ...Can ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
Auto Parallel Load uses the inferred schema to generate CREATE TABLE statements. MySQL 9.0.0 adds support for Lakehouse Incremental Load with the refresh_external_tables option, see: Section 4.3.13.2, “Refresh Data Using Incremental Load”. This ...input_list is a JSON array and requires one or more valid input which can be either a valid schema name or a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-par.html
Review the following examples to see the different ways to use pre-authenticated requests (PAR) to specify files when creating external tables manually. Create the external tables that will ingest the loaded data by either using SQL syntax or JSON ...Types of PARs You can create the following types of PARs: Bucket or prefix PAR: This type of PAR ends with ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-fulltext_index-tables.html
INNODB_FT_DEFAULT_STOPWORD: Holds a list of stopwords that are used by default when creating a FULLTEXT index on InnoDB tables. use_stopword: Indicates whether a stopword table is used, which is defined when the FULLTEXT index is created.
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-how-to-import-onnx.html
For example: mysql> CREATE DATABASE onnx_model; mysql> USE onnx_model; Create a table with only one column to store the string. The following example creates the onnx_temp table with the onnx_string column with the LONGTEXT data type. mysql> CREATE ...Import model as a string: For smaller models, you can copy the encoded string and paste it into a session variable or temporary table ...