Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
This section provides information about the way in which MySQL data types are represented in NDBCLUSTER table columns and how these values can be accessed in NDB API applications. The MySQL TINYINT, SMALLINT, INT, and BIGINT data types map to NDB ...The storage space required for a MySQL CHAR column is determined by the maximum number of characters and the column's character ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-move-data.html
Usage The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally with the database name. ndb_move_data options source target Options that can be used with ndb_move_data are shown in the ...--abort-on-error Command-Line Format --abort-on-error Dump core on permanent error (debug ...--character-sets-dir=name Command-Line ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam-bulk-data-loading.html
For a MyISAM table, you can use concurrent inserts to add rows at the same time that SELECT statements are running, if there are no deleted rows in middle of the data file. With some extra work, it is possible to make LOAD DATA run even faster for a ... These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-data-types.html
Columns with unsupported data types must be excluded, and defined as NOT SECONDARY before loading a table. JSON As of MySQL 9.0.0, the JSON data type supports the following functions and operators: Cast-functions and operators, see: Section 5.3.3, ...Numeric data types: BIGINT BOOL DECIMAL DOUBLE FLOAT INT INTEGER MEDIUMINT SMALLINT TINYINT Temporal data types: DATE DATETIME TIME TIMESTAMP YEAR Temporal types are only supported with strict SQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-compression.html
More data per node reduces costs by minimizing the size of the MySQL HeatWave Cluster required to store the data. If data storage size is not a concern, disable data compression by setting the rapid_compression session variable to OFF before loading ... MySQL HeatWave compresses data as it is loaded, which permits MySQL HeatWave nodes to store more ...
https://dev.mysql.com/doc/refman/8.4/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
An expression default value for one column can refer to other table columns, with the exception that references to generated columns or columns with expression default values must be to columns that occur earlier in the table definition. If binary ... Data type specifications can have explicit or implicit default ...Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-reference-errorcodes.html
The following tables lists the error codes returned by Connector/ODBC apart from the server errors.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-errorcodes.html
The following tables lists the error codes returned by Connector/ODBC apart from the server errors.
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-transactional-storage.html
The mysql.ibd tablespace file must reside in the MySQL data directory and its name cannot be modified or used by another tablespace. The data dictionary schema stores dictionary data in transactional (InnoDB) tables. Data dictionary tables are ...