Search Results
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
Topics in this section: Message Structure Message Sequence Common Messages Connection Session Expectations CRUD SQL Result Sets Expressions Data Types This section provides detailed information about how X Protocol defines messages. Message ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-insert-select.html
This topic describes how to run a SELECT query and insert the results into a target table using the INSERT ... The target table can be an InnoDB table and does not need to use a secondary engine. When the query is offloaded to MySQL HeatWave, it is ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-import.html
Use the ML_MODEL_IMPORT routine to import a pre-trained model into your model catalog. To learn how to use ML_MODEL_IMPORT to share models, see Share a Model. ML_MODEL_IMPORT Overview ML_MODEL_IMPORT Syntax ML_MODEL_IMPORT Parameters Syntax ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-train-test-split.html
MySQL 9.4.1 introduces the TRAIN_TEST_SPLIT routine, which automatically splits your data into training and testing datasets. Two new tables in the same database are created with the following names: [original_table_name]_train ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-estimate-cluster-size.html
Estimating Cluster Memory Size with MySQL HeatWave Autopilot 4.1.1 Estimating Cluster Memory Size with MySQL HeatWave Autopilot This topic describes how to estimate the optimal MySQL HeatWave Cluster size for your data. A cluster size estimate is ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-workspace-managing-hw-data.html
Data is loaded into MySQL HeatWave from the associated DB System. If you have not loaded data into the DB System, see Importing Data. Creating Lakehouse Data Mapping: MySQL HeatWave Lakehouse enables query processing on the data residing in an ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value for a column. Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. For InnoDB tables, both tables must use the same row ...