Search Results
https://dev.mysql.com/doc/refman/8.4/en/explain.html
The SHOW CREATE TABLE, SHOW TABLE STATUS, and SHOW INDEX statements also provide information about tables. In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...The same principle applies to other table operations that require modifying data dictionary ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-overview.html
For more information about permitted partitioning column types and partitioning functions, see Section 26.2, “Partitioning Types”, as well as Section 15.1.20, “CREATE TABLE Statement”, which provides partitioning syntax descriptions and ...
https://dev.mysql.com/doc/ndbapi/en/ndb-column.html
Beginning with NDB 8.0.30, you can change the inline size of a blob column in the mysql client by setting BLOB_INLINE_SIZE in a column comment as part of CREATE TABLE or ALTER TABLE. You can increase the blob part size of a blob column to the ...The ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions ...The SET clause indicates which columns to modify and the values they should be ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
Here is an example of how to generate an XID event (it occurs whether or not innodb_support_xa is enabled): CREATE TABLE t1 (a INT) ENGINE = INNODB; START TRANSACTION; INSERT INTO t1 VALUES (1); COMMIT; Fixed data part: Empty Variable data part: 8 ...In MySQL 4.0 and 4.1, such events are written only to the first binary log file that mysqld creates after ... The following ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is ...Row Formats The row format of an InnoDB table determines how its rows are physically stored on ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. It is important to create good ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
When creating a table with the the VECTOR data type, you can provide the model to use in the ENGINE_ATTRIBUTE for either the column or table. If you are on a version earlier than MySQL 9.4.0, you must use CREATE TABLE and set ENGINE to lakehouse, ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-learn-with-genai.html
| | \n\nFirst, let's integrate the tables into one full table using a `CREATE TABLE ... Identify columns that should be excluded from training and provide a JSON array.\n\n```json | | \nJSON_ARRAY('x0', 'table_1_id', 'table_2_id', 'table_3_id', ...