Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-engine.html
SHOW ENGINE INNODB MUTEX output has these columns: Type Always InnoDB. The connection row's Status column contains the name-value pairs described in the following table. An NdbBlob is created for each new operation involving a BLOB column in an NDB ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
If the first argument is a constant string and the second is a column of type SET, the FIND_IN_SET() function is optimized to use bit arithmetic. For example, '41' is stored into a CHAR(3) column as '41 ' and retrieved as '41' (with the trailing pad ...For functions that operate on string positions, the first position is ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
If this happens in a table's constraints, default expressions, partitioning expressions, or virtual columns, the table could not be opened. (Bug #116463, Bug #37212019) InnoDB: Under certain circumstances, using ALTER TABLE with INPLACE to modify ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-restore-cluster.html
When this option is used, restore cluster ignores any columns missing from tables being restored as compared to the versions of those tables found in the backup. Using --lossy-conversions allows lossy conversions of column values (type demotions or ...Stop the cluster using stop cluster, then restart it using start cluster with the --initial option, which causes the data node file systems to be ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-4.html
(Bug #36951132) NDB Disk Data: mysqld did not use a disk scan for NDB tables with 256 disk columns or more. For tables using the NDB storage engine, the column comment option BLOB_INLINE_SIZE was silently ignored for TINYBLOB columns, and (silently) ... MySQL NDB Cluster 8.4.4 is a new LTS release of NDB 8.4, based on MySQL Server 8.4 and including features in version 8.4 of the NDB storage engine, as well as fixing recently discovered bugs in previous NDB Cluster ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-train-test-split.html
TRAIN_TEST_SPLIT Syntax mysql> CALL sys.TRAIN_TEST_SPLIT ('table_name', 'target_column_name', [options | NULL]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ['task', ... The TRAIN_TEST_SPLIT routine automatically ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-jdbc-compliance.html
useColumnNamesInFindColumn Prior to JDBC-4.0, the JDBC specification had a bug related to what could be given as a column name to result set methods like 'findColumn()', or getters that took a String property. JDBC-4.0 clarified "column name" to ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-blob-serverprep.html
The first step is using MySQL with BLOB data is to configure the server. For this example, use the following table definition: CREATE TABLE file( file_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, file_name VARCHAR(64) NOT NULL, ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-wordexcel.html
Within Microsoft Excel, you can execute queries on your MySQL server and import the data directly into an Excel Worksheet, presenting the data as a series of rows and columns. Figure 5.30 Microsoft Query Wizard: Choose Data Source Dialog Within the ... You can use Microsoft Word and Microsoft Excel to access information from a MySQL database using ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-description.html
Syntax: tuples = cursor.description This read-only property returns a list of tuples describing the columns in a result set. Each tuple in the list contains values as follows: (column_name, type, None, None, None, None, null_ok, column_flags) The ...To see how to interpret it, do this: >>> from mysql.connector import FieldFlag >>> FieldFlag.desc ...