Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-sharing.html
Run the SHOW CREATE TABLE command to confirm the table was created with the recommended parameters for importing. This topic describes how to grant other users access to a model you create. Share Your Models To share a model you created, you can ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html
CREATE TABLE t1 ( ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ); With a DEFAULT clause but no ON UPDATE CURRENT_TIMESTAMP clause, the column has the given ...
https://dev.mysql.com/doc/refman/8.4/en/insert.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. | TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-embeddings.html
Using this method, you can create vector embedding tables that you can use to perform similarity searches using the DISTANCE() function, without setting up a vector store. Note In versions older than MySQL 9.2.1, to alter an existing table or create ...You can pass the text string in the routine manually or use data from tables in your ... This section ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1 filtered: 100.00 Extra: NULL *************************** 2. row *************************** ...It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-examples.html
If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table options. With row-based format, DML statements are handled based on the database where the modified table ...It is also important to note that the results vary ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
(The CREATE TABLE statement in MySQL 8.4 creates InnoDB tables by default.) MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. You can create tables with ... Storage engines are MySQL components that handle the SQL operations for different table ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-dict-obj-tree.html
This means that you must know the name of any tablespace or log file group associated with a given table, or obtain this information from SHOW CREATE TABLE and then querying INFORMATION_SCHEMA.FILES, or similar means as shown here: mysql> SHOW ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
(Bug #36259487) InnoDB: A schema mismatch was possible when a table was imported with a different sql_mode than when it was created, because strict mode influences the number of nullable columns in a table's secondary index. In certain rare cases, a ...This had an adverse effect on queries using joins on InnoDB ... C API Notes Compilation Notes Configuration Notes SQL Function and Operator Notes JavaScript Programs Performance Schema Notes sys Schema Notes Thread Pool Notes Functionality Added or Changed Bugs Fixed C API Notes The asynchronous ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html
To avoid problems caused by such differences, it is best to adopt a consistent convention, such as always creating and referring to databases and tables using lowercase names. Value Meaning 0 Table and database names are stored on disk using the ...