Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-functions.html
CREATE FUNCTION GTID_INTERSECTION(gs1 LONGTEXT, gs2 LONGTEXT) RETURNS LONGTEXT RETURN GTID_SUBTRACT(gs1, GTID_SUBTRACT(gs1, gs2)) | This function returns the symmetric difference between two GTID sets, that is, the GTIDs that exist in gs1 but not in ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
BIT BIT BOOLEAN TINYINT(1) REAL FLOAT DOUBLE PRECISION DOUBLE NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL(19,2) CHAR CHAR/LONGTEXT Depending on its length. DATE DATE TIME TIME TIMESTAMP DATETIME INTERVAL TIME BYTEA LONGBLOB TEXT LONGTEXT CIDR ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
REAL FLOAT NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL SMALLMONEY DECIMAL CHAR CHAR/LONGTEXT Depending on its length. The following table shows the mapping between Microsoft SQL Server (source) data types and MySQL data types. Table 10.2 Type ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-how-to-import-onnx.html
The following example creates the onnx_temp table with the onnx_string column with the LONGTEXT data type. mysql> CREATE TABLE onnx_temp (onnx_string LONGTEXT); Use a LOAD DATA LOCAL INFILE statement to load the pre-processed .onnx file into the ...
https://dev.mysql.com/doc/internals/en/mismatch-of-focus-of-test-and-code-sequence.html
CREATE TABLE t1 ( id INT NOT NULL AUTO_INCREMENT, my_column VARCHAR(30), name LONGTEXT, PRIMARY KEY (id)); INSERT INTO t1(my_column,name) VALUES('2','two'); INSERT INTO t1(my_column,name) VALUES('1','one'); INSERT INTO t1(my_column,name) ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-how-to-import-onnx.html
The following example creates the onnx_temp table with the onnx_string column with the LONGTEXT data type. mysql> CREATE TABLE onnx_temp (onnx_string LONGTEXT); Use a LOAD DATA INFILE statement to load the pre-processed .onnx file into the temporary ... This topic describes how to import an external ONNX ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-model-import.html
The table to import should have the following columns, and their recommended parameters: chunk_id: INT AUTO_INCREMENT PRIMARY KEY model_object: LONGTEXT NOT NULL model_metadata: JSON DEFAULT NULL See Model Metadata. Use the ML_MODEL_IMPORT routine ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
LONGTEXT [CHARACTER SET charset_name] [COLLATE collation_name] A TEXT column with a maximum length of 4,294,967,295 or 4GB (232 − 1) characters. The effective maximum length of LONGTEXT columns also depends on the configured maximum packet size in ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
JSON_UNQUOTE() returns a value with a data type of LONGTEXT, and the hidden generated column thus is assigned the same data type. MySQL cannot index LONGTEXT columns specified without a prefix length on the key part, and prefix lengths are not ...