Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
Here is a sample session that demonstrates use of mysqlimport: $> mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test $> ed a 100 Max Sydow 101 Count Dracula . Invoke mysqlimport like this: mysqlimport [options] db_name textfile1 [textfile2 ... The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-an-anomaly-detection-model.html
mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the table to insert the sample data into. mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location ...To ... This topic describes how to prepare the data to use for two anomaly detection machine learning models: a semi-supervised anomaly detection model, and an unsupervised anomaly detection model for ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-an-anomaly-detection-model.html
mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the table to insert the sample data into. mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location ...To ... This topic describes how to prepare the data to use for two anomaly detection machine learning models: a semi-supervised anomaly detection model, and an unsupervised anomaly detection model for ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...A B-tree index on spatial values is useful for exact-value lookups, but not for range ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
Move the pointer over an acronym to view a description, and see Section 8.1.10.2, “Columns Tab”, and the documentation for the CREATE TABLE for additional details. What is a MySQL connection? Why might I need to create more than one? A.2. How do ... FAQ Categories Basic Usage MySQL Workbench Functionality Data Management General Basic Usage ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-tablespace-autoextend-size.html
When a file-per-table or general tablespace is created with a non-zero AUTOEXTEND_SIZE setting, the tablespace is initialized at the specified AUTOEXTEND_SIZE size. For tables created in file-per-table tablespaces, SHOW CREATE TABLE shows the ... By ...For information about extent size, see Section 17.11.2, “File Space ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-4-0.html
Additionally, NL2ML offers a chat-bot interface for follow-up questions and leverages your schemas, tables, and columns to create personalized AutoML queries. (WL #16836) MySQL HeatWave Lakehouse MySQL HeatWave Lakehouse now supports creation and ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...The ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-options-tab.html
See CREATE TABLE Statement for more information on how to use these options. To create a MERGE table, select MERGE as your storage engine and then specify the MyISAM tables you wish to merge in the Union Tables dialog. Figure 8.19 The Options Tab ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-table-distribution-status.html
The table_distribution_status table provides information about the progress of table distribution for NDB tables. is_reorg_ongoing Whether the table is currently being reorganized (1 if true) .