PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/gis-wkb-functions.html
LineFromWKB(wkb [, srid]), LineStringFromWKB(wkb [, srid]) ST_LineFromWKB(), ST_LineStringFromWKB(), LineFromWKB(), and LineStringFromWKB() are synonyms. LineFromWKB() and LineStringFromWKB() are deprecated; expect them to be removed in a future ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-example.html
This should be similar to what is shown here, where password is the MySQL root password for a given MySQL server instance: $> mysqladmin -uroot -ppassword shutdown 081208 20:19:56 mysqld_safe mysqld from pid file /usr/local/mysql/var/tonfisk.pid ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html
An example follows, where c1 is an AUTO_INCREMENT column of table t1: INSERT INTO t1 (c1,c2) VALUES (1,'a'), (NULL,'b'), (5,'c'), (NULL,'d'); Another type of “mixed-mode insert” is INSERT ... To make this clear, consider an example that uses ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
Running ALTER TABLE tbl_name ENGINE=INNODB on an existing InnoDB table performs a “null” ALTER TABLE operation, which can be used to defragment an InnoDB table, as described in Section 14.12.4, “Defragmenting a Table”. The outcome of ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
Return value: The password string for success (up to 766 bytes), or NULL and an error for failure. Return value: If the call succeeds, the return value is a binary JSON string containing an array of audit events, or a JSON null value if that was ...
https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT CONCAT(2,' test'); -> '2 test' It is also possible to convert a number to a string explicitly using the CAST() ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
An SQL NULL value reserves one or two bytes in the record directory. An SQL NULL value reserves zero bytes in the data part of the record if stored in a variable-length column. Reserving fixed space for NULL values permits columns to be updated in ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
In addition, for a non-transactional update, if a disk write failure occurs while attempting to write to the binary log cache and a gap is therefore created in the binary log, the resulting incident log event is assigned a GTID. When you issue RESET ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the replication source ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-worker.html
On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator and replication_applier_status_by_worker show status information for the replica's coordinator thread and applier worker threads respectively. For a ...
https://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html
XA transaction support is limited to the InnoDB storage engine. For “external XA,” a MySQL server acts as a Resource Manager and client programs act as Transaction Managers. For “Internal XA”, storage engines within a MySQL server act as ...