MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 121 to 130 of 130 total results

« Previous
11
12
13
Next »

https://dev.mysql.com/doc/refman/8.0/en/select-into.html

This is useful for selecting a BLOB value and storing it in a file. INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ... Column and line terminators can be specified to produce a specific output ...

15.7.7.15 SHOW ENGINE Statement

https://dev.mysql.com/doc/refman/8.0/en/show-engine.html

NdbBlob: The number and size of NdbBlob objects that have been created. An NdbBlob is created for each new operation involving a BLOB column in an NDB table. SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information ...

15.7.7.22 SHOW INDEX Statement

https://dev.mysql.com/doc/refman/8.0/en/show-index.html

However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...

15.7.7.38 SHOW TABLE STATUS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html

For NDB tables, the output of this statement shows appropriate values for the Avg_row_length and Data_length columns, with the exception that BLOB columns are not taken into account. SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE ...

17.6.2.3 Sorted Index Builds

https://dev.mysql.com/doc/refman/8.0/en/sorted-index-builds.html

It does not apply to external pages used for TEXT or BLOB entries. InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. This method of index creation is also known as a sorted index build.

11.1.1 String Literals

https://dev.mysql.com/doc/refman/8.0/en/string-literals.html

A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") characters. Examples: 'a string' "another string" Quoted strings placed next to each other are concatenated to a single string. The following ...

13.3 String Data Types

https://dev.mysql.com/doc/refman/8.0/en/string-types.html

The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 13.7, “Data Type Storage Requirements”. For descriptions of functions that ...

10.2.2.2 Optimizing Subqueries with Materialization

https://dev.mysql.com/doc/refman/8.0/en/subquery-materialization.html

The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...

10.4.6 Limits on Table Size

https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html

ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only for tables with BLOB or TEXT columns; in this case, MySQL cannot optimize the space required based only on the number of rows. The effective ...

3.5 Changes in MySQL 8.0

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html

It should be as big as the largest Section 13.3.4, “The BLOB and TEXT Types” you want to use. Before upgrading to MySQL 8.0, review the changes described in this section to identify those that apply to your current MySQL installation and ...

Displaying 121 to 130 of 130 total results

« Previous
11
12
13
Next »