PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-syntax.html
The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6), ts TIMESTAMP(0)); The fsp value, if given, must be in the range 0 to 6. Note As of ...For the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there is no ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node.html
This section describes how to add NDB Cluster data nodes “online”—that is, without needing to shut down the cluster completely and restart it as part of the process. Important Currently, you must add new data nodes to an NDB Cluster as part ...In addition, it is not possible to change the number of fragment replicas (or the number of nodes per node group) ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-sql-format.html
This has several implications: When you reload the dump file, you must specify a default database name so that the server knows which database to reload. This ensures that when the dump file is reloaded, it creates each database if it does not exist ...Without this option, mysqldump treats the first name as a database name and those following as table ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-numeric.html
Information in the database is likely to be stored in a more compact format than in the text file, so accessing it involves fewer disk accesses. If you are using numeric data, it is faster in many cases to access information from a database (using a ... For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-decimal-characteristics.html
This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range ...The ranges of values for the arguments are as follows: M is the maximum number of digits (the ...Each multiple ...
https://dev.mysql.com/doc/refman/8.0/en/retrieving-data.html
This can be a list of columns, or * to indicate “all columns.” which_table indicates the table from which you want to retrieve data. The SELECT statement is used to pull information from a table. The general form of the statement is: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-object-cache.html
The dictionary object cache is a shared global cache that stores previously accessed data dictionary objects in memory to enable object reuse and minimize disk I/O. Similar to other cache mechanisms used by MySQL, the dictionary object cache uses ...character set definition cache partition: Stores character set definition objects and has a hardcoded object limit of ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
The rows of an InnoDB table are stored in a clustered index organized based on the primary key, forming what some database systems call an “index-organized table”. Dropping a column default value ALTER TABLE tbl ALTER COLUMN col DROP DEFAULT, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
17.8.10.1.5 InnoDB Persistent Statistics Tables The persistent statistics feature relies on the internally managed tables in the mysql database, named innodb_table_stats and innodb_index_stats. row *************************** database_name: sakila ...Because of the asynchronous nature of automatic statistics recalculation, which occurs in the background, statistics may not be recalculated instantly after running a DML operation that affects more than 10% of a table, even when innodb_stats_auto_recalc is ...