PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/json-utility-functions.html
When the argument is a JSON column, this is the space used to store the JSON document as it was inserted into the column, prior to any partial updates that may have been performed on it afterwards. This section documents utility functions that act ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin directory. This program reads the files created as a result of the backup and inserts the stored ...In ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
As with the other partitioning examples, we assume that the default_storage_engine is InnoDB.) Suppose that there are 20 video stores distributed among 4 franchises as shown in the following table. For instance, suppose that all stores in the West ... List partitioning in MySQL is similar to range partitioning in many ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-event-tables.html
For wait, stage, statement, and transaction events, the Performance Schema can monitor and store current events. In addition, when events end, the Performance Schema can store them in history tables. The tables have names of the following forms, ...
https://dev.mysql.com/doc/refman/8.0/en/serialized-dictionary-information.html
In addition to storing metadata about database objects in the data dictionary, MySQL stores it in serialized form. Other storage engines store SDI data in .sdi files that are created for a given table in the table's database directory. For ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
This may be useful for Web applications that obtain year, month, and day in three different fields and store exactly what the user inserted, without date validation. It is always permissible to have spaces after a loadable function or stored ... The ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. For example: SET time_zone = 'MET'; Unique UTC values stored in the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-collations.html
Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary. Nonbinary strings (as stored using the CHAR, VARCHAR, and TEXT data types) have a character set and collation other than ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns. Even with additional write costs, secondary indexes on virtual columns may be preferable to ...A ...