PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-restrictions.html
If a source used STATEMENT format and a replica used ROW format, the replica would be unable to handle the transaction correctly, therefore the CREATE TABLE ... CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements are not supported inside ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
In addition, because temporary tables can be read only from the thread which created them, there is seldom if ever any benefit obtained from replicating them, even when using statement-based format. You can switch from statement-based to row-based ... MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads.html
The source creates a thread to send the binary log contents to a replica when the replica connects. When a START SLAVE statement is issued on a replica server, the replica creates an I/O thread, which connects to the source and asks it to send the ... MySQL replication capabilities are implemented using three main threads, one on the source server and two on the replica: Binary log dump ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 11.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-syntax.html
Stored routines are created with the CREATE PROCEDURE and CREATE FUNCTION statements (see Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”). A stored routine is either a procedure or a function. A procedure is invoked using a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...
https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. A reason to specify TEMPTABLE explicitly is that locks can be released on underlying tables after the temporary table has been created and before it ...For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace corresponding parts of the ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...
https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
The DROP DATABASE statement removes from the given database directory those files and directories that MySQL itself may create during normal operation: All files with the following extensions: .BAK .DAT .HSH .MRG .MYD .MYI .TRG .TRN .cfg .db .frm ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, like this: mysql> ALTER TABLE tbl AUTO_INCREMENT = 100; InnoDB Notes For information about AUTO_INCREMENT usage specific to InnoDB, see Section ...