Search Results
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
When rows are inserted in sorted order (as when you are using an AUTO_INCREMENT column), the index tree is split so that the high node only contains one key. (When an AUTO_INCREMENT column is defined as the last column of a multiple-column index, ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
insert_id The value to be used by the following INSERT or ALTER TABLE statement when inserting an AUTO_INCREMENT value. If no AUTO_INCREMENT value was successfully inserted, the SELECT statement returns no row. The behavior of retrieving an ... The ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). The schema_auto_increment_columns view ...By default, rows are sorted by descending usage ratio and maximum column ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-byo-embedding-tables.html
GenAI lets you use tables containing your own vector embedding to run retrieval-augmented generation (RAG) with vector search. The ML_RAG and ML_RAG_TABLE routines let you specify the table column names to use as filters for finding relevant tables ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/glossary.html
These terms are commonly used in information about MySQL Enterprise Monitor. A access control MySQL Enterprise Monitor Access Control enables you to manage asset visibility, application administration, data access, roles, and users. advisor ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-import.html
The table to import should have the following columns, and their recommended parameters: chunk_id: INT AUTO_INCREMENT PRIMARY KEY model_object: LONGTEXT NOT NULL model_metadata: JSON DEFAULT NULL See Model Metadata. Use the ML_MODEL_IMPORT routine ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-an-anomaly-detection-model.html
mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location VARCHAR(100), purchase_amount DECIMAL(10, 2), purchase_time DATETIME, target INT ); Insert the sample data to train ... 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/archive-storage-engine.html
The AUTO_INCREMENT column can have either a unique or nonunique index. The ARCHIVE engine also supports the AUTO_INCREMENT table option in CREATE TABLE statements to specify the initial sequence value for a new table or reset the sequence value for ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-literals.html
Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...