Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-prepare.html
mysql> CREATE DATABASE regression_data; mysql> USE regression_data; Create the table to insert the sample data into. mysql> CREATE TABLE house_price_training ( id INT PRIMARY KEY, house_size INT, address TEXT, state TEXT, price INT ); Insert the ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-2-1.html
MySQL HeatWave GenAI MySQL HeatWave MySQL HeatWave GenAI Context search in MySQL HeatWave GenAI now lets you use your own embedding tables. This update extends the search capabilities of the ML_RAG, ML_RAG_TABLE, and HEATWAVE_CHAT routines to ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html
You must use a column alias with the value of the column to the actual name of the BLOB, for example: SELECT id, 'data' as blob_data from blobtable You must also follow these rules: The SELECT must reference only one table. The SELECT must alias the ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
You can do so by creating tables to hold your data and loading them with the desired information. Then you can answer different sorts of questions about your animals by retrieving data from the tables. Once you know how to enter SQL statements, you ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET'); -> '2004-01-01 13:00:00' mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00'); -> '2004-01-01 22:00:00' Note To use named time zones such as 'MET' or 'Europe/Amsterdam', the ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/8.4/en/descending-indexes.html
For InnoDB full-text search, this means that the index required on the FTS_DOC_ID column of the indexed table cannot be defined as a descending index. MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes ...
https://dev.mysql.com/doc/refman/8.4/en/environment-variables.html
This section lists environment variables that are used directly or indirectly by MySQL. Most of these can also be found in other places in this manual. Options on the command line take precedence over values specified in option files and ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-components.html
A sink may also write to the Performance Schema error_log table; see Section 29.12.22.2, “The error_log Table”. For a sink component, whether it supports an interface to the Performance Schema error_log table. This section describes the ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-information-schema.html
Can I add to or otherwise modify the tables found in the INFORMATION_SCHEMA database? A.7.1. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? See Chapter 28, INFORMATION_SCHEMA Tables. What is the difference between the ...
https://dev.mysql.com/doc/refman/8.4/en/foreign-key-optimization.html
If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the ...Depending on how the data is distributed, the queries might perform less I/O and take up less cache memory because the relevant columns are packed together on ...