Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-handles.html
If you do not specify a model handle name, a model handle is automatically generated that is based on the database name, input table name, the user name training the table, and a unique numerical identifier. In the following example, @census_model ... When ML_TRAIN trains a model, you have the option to specify a name for the model, which is the model ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-topic-modeling.html
The following tasks use a dataset generated by OCI GenAI using Meta Llama Models. To generate your own datasets to create machine learning models in MySQL AI, learn how to Generate Text-Based Content. Topic modeling is an unsupervised machine ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-vector-store-overview.html
Therefore, the responses generated by these LLMs are based on publicly available information. To generate content relevant to your proprietary data, you must store your proprietary enterprise data, which has been converted to vector embeddings, in a ... This section describes the Vector Store functionality available with ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-wait-summary-tables.html
The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index table_io_waits_summary_by_table: Table I/O waits per table table_lock_waits_summary_by_table: Table lock ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
An expression default value for one column can refer to other table columns, with the exception that references to generated columns or columns with expression default values must be to columns that occur earlier in the table definition. That is, ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
If you store values larger than the display width in an integer column that has the ZEROFILL attribute, you may experience problems when MySQL generates temporary tables for some complicated joins. Inserting NULL to generate AUTO_INCREMENT values ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
--ndb-default-column-format=[FIXED|DYNAMIC] Command-Line Format --ndb-default-column-format={FIXED|DYNAMIC} System Variable ndb_default_column_format Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value FIXED Valid Values ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
A generated column in a view is considered updatable because it is possible to assign to it. For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. For example, if a view is defined as SELECT * on a ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. However, if such a column is updated explicitly, the only permitted value is DEFAULT. Also, only a single table in the view definition can be ... Some views are updatable and references to them can be used to specify tables to be updated in data change ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
For ALTER TABLE statements, ADD COLUMN is not supported for external tables. This topic contains the following sections: CREATE TABLE Statement External Table Options with SQL Syntax Column Definitions Table Parameters File Specifications File ...