MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 71 to 80 of 86 total results

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

mysql> SELECT LENGTH('text'); -> 4 Note The Length() OpenGIS spatial function is named ST_Length() in MySQL. For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, noninteger ...

15.7.3.1 ANALYZE TABLE Statement

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

Histogram generation applies to columns of all data types except geometry types (spatial data) and JSON. ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] ANALYZE [NO_WRITE_TO_BINLOG | ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/8.0/en/user-variables.html

For example, a value having a temporal or spatial data type is converted to a binary string. You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one ...

6.5.6 mysqlpump — A Database Backup Program

https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html

The affected data types are BINARY, VARBINARY, BLOB types, BIT, all spatial data types, and other non-binary data types when used with the binary character set. mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions ...

15.8.3 HELP Statement

https://dev.mysql.com/doc/refman/8.0/en/help.html

HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, ...

28.4.20 The INFORMATION_SCHEMA INNODB_INDEXES Table

https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-indexes-table.html

0 = nonunique secondary index; 1 = automatically generated clustered index (GEN_CLUST_INDEX); 2 = unique nonclustered index; 3 = clustered index; 32 = full-text index; 64 = spatial index; 128 = secondary index on a virtual generated column. For ...

17.9.2 InnoDB Page Compression

https://dev.mysql.com/doc/refman/8.0/en/innodb-page-compression.html

R-tree pages, which are used for spatial indexes, are not compressed. InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE ...

17.6.2.3 Sorted Index Builds

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

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. In the first phase, the clustered index is scanned, and index ...

11.3 Keywords and Reserved Words

https://dev.mysql.com/doc/refman/8.0/en/keywords.html

Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...

17.16.1 Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema

https://dev.mysql.com/doc/refman/8.0/en/monitor-alter-table-performance-schema.html

Note InnoDB ALTER TABLE stage events do not currently account for the addition of spatial indexes. You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. There are seven stage events that represent different phases of ...

Displaying 71 to 80 of 86 total results