Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-load.html
To set up a new vector store using an object URI, perform the following steps: To create the vector store table, use a new or existing database: mysql>USE DBName; Replace DBName with the database name. In earlier versions of MySQL, if you are ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified. CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 ... ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
If the thread spawns a subthread, matching occurs again for the threads table row created for the subthread. If the thread spawns a subthread, matching occurs again for the threads table row created for the subthread. The threads table contains a ...Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it: mysql> SELECT * FROM performance_schema.threads\G *************************** ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-explanations-ml-explain-table.html
ML_EXPLAIN_TABLE explains predictions for an entire table of unlabeled data. We recommend limiting the input table to a maximum of 100 rows. If the input table has more than ten columns, limit it to ten rows. Some of these columns include: ...The ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-predict-table.html
ML_PREDICT_TABLE generates predictions for an entire table of unlabeled data. ML_PREDICT_TABLE Overview ML_PREDICT_TABLE Syntax Required ML_PREDICT_TABLE Parameters ML_PREDICT_TABLE Options Options for Recommendation Models Requirements and Options ...The output of predictions includes the ml_results column, which contains the prediction results and the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
However, the order of the column names in the partitioning column list and the value lists does not have to be the same as the order of the table column definitions in the main part of the CREATE TABLE statement. In addition, changing the character ...As with table partitioned by RANGE, you can use MAXVALUE to represent a value such that any legal value inserted into a given column is always less than this ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
To display the current structure of the log tables, use these statements: SHOW CREATE TABLE mysql.general_log; SHOW CREATE TABLE mysql.slow_log; Log contents are accessible through SQL statements. CREATE TABLE, ALTER TABLE, and DROP TABLE are valid ...Possible destinations for log entries are log files or the general_log and slow_log tables in the mysql system ... MySQL Server provides flexible ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
Changing the server SQL mode after creating and inserting data into partitioned tables can cause major changes in the behavior of such tables, and could lead to loss or corruption of data. It is strongly recommended that you never change the SQL ...
https://dev.mysql.com/doc/refman/8.4/en/temporary-table-problems.html
Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported only by the InnoDB, MEMORY, MyISAM, and MERGE storage engines. It may occur for temporary tables created outside stored functions ...
https://dev.mysql.com/doc/refman/8.4/en/drop-table.html
A TEMPORARY table is visible only with the session that created it, so no check is necessary. Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the ...They are permitted to make porting easier from other database ...