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/manual-info.html
For example, while working with replication the commands might be prefixed with source and replica: source> type a mysql statement on the replication source here replica> type a mysql statement on the replica here Database, table, and column names ... This is the Reference Manual for the MySQL Database System, version 8.0, through release ...Differences between minor ...
https://dev.mysql.com/doc/refman/8.0/en/windows-select-server.html
The following table shows the available servers for Windows in MySQL 8.0. Binary Description mysqld Optimized binary with named-pipe support mysqld-debug Like mysqld, but compiled with full debugging and automatic memory allocation checking All of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-connection-status-table.html
LAST_ERROR_NUMBER, LAST_ERROR_MESSAGE The error number and error message of the most recent error that caused the I/O thread to stop. An error number of 0 and message of the empty string mean “no error.” If the LAST_ERROR_MESSAGE value is not ...
https://dev.mysql.com/doc/refman/8.0/en/gis-linestring-property-functions.html
If the length computation result is +inf, an ER_DATA_OUT_OF_RANGE error occurs. If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. ST_IsClosed() handles its arguments as described in the ...You ...ST_IsClosed() returns 0 if ls is not closed, and NULL if ls is ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-columns.html
Columns with a spatial data type can have an SRID attribute, to explicitly indicate the spatial reference system (SRS) for values stored in the column. Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. See also the notes ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication.html
Normal (non-clustered) replication involves a source server and a replica server, the source being so named because operations and data to be replicated originate with it, and the replica being the recipient of these. We refer to the MySQL source ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-blob.html
Do not use this technique when the entire table is compressed by InnoDB or MyISAM. Since the performance requirements to retrieve and display a BLOB value might be very different from other data types, you could put the BLOB-specific table on a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-member-actions.html
The server must be writeable (with the read_only system variable set to OFF) and have the Group Replication plugin installed. When the feature is active and correctly configured, if the primary that is replicating goes offline or into an error ...
https://dev.mysql.com/doc/refman/8.0/en/derived-tables.html
The [AS] tbl_name clause is mandatory because every table in a FROM clause must have a name. The number of column names must be the same as the number of table columns. Before 8.0.14, it produces an error: Unknown column 't1.b' in 'where clause' The ...For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived ...
https://dev.mysql.com/doc/refman/8.0/en/charset-column.html
If you use ALTER TABLE to convert a column from one character set to another, MySQL attempts to map the data values, but if the character sets are incompatible, there may be data loss. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE ...