PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/date-and-time-types.html
The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For information about storage requirements of the temporal data types, see Section 13.7, “Data Type Storage Requirements”. Although ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-type-overview.html
The other spatial data types hold collections of values: MULTIPOINT MULTILINESTRING MULTIPOLYGON GEOMETRYCOLLECTION GEOMETRYCOLLECTION can store a collection of objects of any type. For other examples showing how to use spatial data types in MySQL, ... MySQL has spatial data types that correspond to OpenGIS ...Spatial columns with no SRID ...
https://dev.mysql.com/doc/refman/8.0/en/selecting-all.html
For example, you may happen to think that the birth date for Bowser doesn't seem quite right. Consulting your original pedigree papers, you find that the correct birth year should be 1989, not 1979. Fix only the erroneous record with an UPDATE ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
CREATE UNDO TABLESPACE tablespace_name ADD DATAFILE 'file_name.ibu'; The undo tablespace file name must have an .ibu extension. Undo tablespace files must be discovered and opened before redo recovery and before other data files are opened to permit ...If the innodb_undo_directory variable is undefined, default undo tablespaces are created in the data ... Undo tablespaces contain undo logs, which are collections of ...
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/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 ...