MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 31 to 40 of 44 total results

14.3 Type Conversion in Expression Evaluation

https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html

When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...

15.7.3.4 OPTIMIZE TABLE Statement

https://dev.mysql.com/doc/refman/9.7/en/optimize-table.html

OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the table. The exact changes made to each table depend on the storage engine used by that ...

6.5.4 mysqldump — A Database Backup Program

https://dev.mysql.com/doc/refman/9.7/en/mysqldump.html

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 data. It dumps one or more MySQL databases for backup or transfer to ...

6.6.9.2 mysqlbinlog Row Event Display

https://dev.mysql.com/doc/refman/9.7/en/mysqlbinlog-row-events.html

The following examples illustrate how mysqlbinlog displays row events that specify data modifications. These correspond to events with the WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT type codes. The --base64-output=DECODE-ROWS and ...

25.2.6.1 Differences Between the NDB and InnoDB Storage Engines

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndb-innodb-engines.html

The NDB storage engine is implemented using a distributed, shared-nothing architecture, which causes it to behave differently from InnoDB in a number of ways. For those unaccustomed to working with NDB, unexpected behaviors can arise due to its ...

14.17.5 Functions That Return JSON Value Attributes

https://dev.mysql.com/doc/refman/9.7/en/json-attribute-functions.html

The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...

28.3.40 The INFORMATION_SCHEMA STATISTICS Table

https://dev.mysql.com/doc/refman/9.7/en/information-schema-statistics-table.html

The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...

MySQL Glossary

https://dev.mysql.com/doc/refman/9.7/en/glossary.html

These terms are commonly used in information about the MySQL database server. Files with this extension are always included in backups produced by the mysqlbackup command of the MySQL Enterprise Backup product. Files with this extension are always ...

1.2.2 The Main Features of MySQL

https://dev.mysql.com/doc/refman/9.7/en/features.html

This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL. For information about features as they are introduced into MySQL on a series-specific ...

18.2.3.2 Dynamic Table Characteristics

https://dev.mysql.com/doc/refman/9.7/en/dynamic-format.html

Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. Dynamic format is a little more complex than static ...

Displaying 31 to 40 of 44 total results