PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/string-functions.html
mysql> UPDATE t SET blob_col=LOAD_FILE('/tmp/picture') WHERE id=1; LOCATE(substr,str), LOCATE(substr,str,pos) The first syntax returns the position of the first occurrence of substring substr in string str. mysql> SELECT LOWER('QUADRATICALLY'); -> ...For functions that operate on string positions, the first position is numbered ...
https://dev.mysql.com/doc/refman/9.7/en/cast-functions.html
For example, the following pairs of definitions are equivalent: CHAR(10) CHARACTER SET binary BINARY(10) VARCHAR(10) CHARACTER SET binary VARBINARY(10) TEXT CHARACTER SET binary BLOB If BINARY is invoked from within the mysql client, binary strings ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...
https://dev.mysql.com/doc/refman/9.7/en/column-indexes.html
When you index a BLOB or TEXT column, you must specify a prefix length for the index. For example: CREATE TABLE test (blob_col BLOB, INDEX(blob_col(10))); Prefixes can be up to 767 bytes long for InnoDB tables that use the REDUNDANT or COMPACT row ... The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column ...
https://dev.mysql.com/doc/refman/9.7/en/create-index.html
Additionally, BLOB and TEXT columns can be indexed only for InnoDB, MyISAM, and BLACKHOLE tables. However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html
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 column. Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', ...