PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
For example: ALTER TABLE t MODIFY latin1_text_col TEXT CHARACTER SET utf8mb4; ALTER TABLE t MODIFY latin1_varchar_col VARCHAR(M) CHARACTER SET utf8mb4; If you specify CONVERT TO CHARACTER SET binary, the CHAR, VARCHAR, and TEXT columns are converted ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-operations-per-fragment.html
This currently has the following formats: Base table: DbName/def/TblName BLOB table: DbName/def/NDB$BLOB_BaseTblId_ColNo Ordered index: sys/def/BaseTblId/IndexName Unique index: sys/def/BaseTblId/IndexName$unique The $unique suffix shown for unique ... The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
--hex-blob Command-Line Format --hex-blob Dump binary columns using hexadecimal notation (for example, 'abc' becomes 0x616263). The affected data types are BINARY, VARBINARY, BLOB types, BIT, all spatial data types, and other non-binary data types ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
The BLOB, TEXT, GEOMETRY, and JSON data types cannot be assigned a default value. Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value for a ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
The space required to store a JSON document is roughly the same as for LONGBLOB or LONGTEXT; see Section 13.7, “Data Type Storage Requirements”, for more information. BLOB BIT OPAQUE DATETIME TIME DATE BOOLEAN ARRAY OBJECT STRING INTEGER, DOUBLE ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
You cannot create indexes on NDB table columns that use any of the TEXT or BLOB data types. ON DELETE CASCADE is also not supported where the child table contains one or more columns of any of the TEXT or BLOB types. The NDB API has no special ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html
ndb-blob-read-batch-bytes: Specifies size in bytes that large BLOB reads should be batched into. ndb-blob-write-batch-bytes: Specifies size in bytes that large BLOB writes should be batched into. The following list includes command-line options, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-desc.html
Table 25.31 Command-line options used with the program ndb_desc Format Description Added, Deprecated, or Removed --auto-inc, -a Show next value for AUTO_INCREMENT oolumn if table has one ADDED: NDB 8.0.21 --blob-info, -b Include partition ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-preparation.html
If you are using a release of NDB Cluster prior to NDB 8.0.30, you should also consider increasing the values used with the --ndb-batch-size and --ndb-blob-write-batch-bytes options as well. In NDB 8.0.30 and later, use --ndb-replica-batch-size to ... Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 25.7.2, “General Requirements for NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
--hex-blob Command-Line Format --hex-blob Dump binary columns using hexadecimal notation (for example, 'abc' becomes 0x616263). The affected data types are BINARY, VARBINARY, BLOB types, BIT, all spatial data types, and other non-binary data types ... mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...