PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. When you create a CSV table, the server creates a plain text data file having a name that begins with the table name and has a .CSV extension. The CSV storage ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
The BLOB, TEXT, GEOMETRY, and JSON data types cannot be assigned a default value. Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value for a ...
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
For InnoDB full-text search, this means that the index required on the FTS_DOC_ID column of the indexed table cannot be defined as a descending index. Explicitly specified ASC and DESC designators for HASH, FULLTEXT, and SPATIAL indexes results in ... MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
Why do some LIKE and FULLTEXT searches with CJK characters fail? A.11.12. Sometimes adding or changing a <meta> tag suffices to correct the problem: for example, to insure that the user agent interprets page content as UTF-8, include <meta ... This ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-innodb-change-buffer.html
What types of operations modify secondary indexes and result in change buffering? A.16.2. How much space does InnoDB use for the change buffer? A.16.5. How do I determine the current size of the change buffer? A.16.6. Where can I find additional ...
https://dev.mysql.com/doc/refman/8.0/en/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. An index may use a prefix of ... This section describes some of the important characteristics of the MySQL Database ...
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. The column is also indexed and the optimizer can take that index into account during execution plan ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkt-functions.html
These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier (SRID). For a description of WKT format, see Well-Known Text (WKT) Format. ST_GeomFromText() accepts a WKT value of any ...Functions in this section detect arguments in either Cartesian or geographic spatial reference systems (SRSs), and return results appropriate to the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured previously. 20.2.1.6.1 Adding a Second Instance In order to add a second instance, ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-bootstrap.html
mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of table t1 and the binary log. The process of starting a group for the first ...