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/insert-on-duplicate.html
If you specify the CLIENT_FOUND_ROWS flag to the mysql_real_connect() C API function when connecting to mysqld, the affected-rows value is 1 (not 0) if an existing row is set to its current values. ON DUPLICATE KEY UPDATE inserts or updates a row, ... If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-encrypted-file-plugin.html
The keyring_encrypted_file plugin supports the functions that comprise the standard MySQL Keyring service interface. Keyring operations performed by those functions are accessible at two levels: SQL interface: In SQL statements, call the functions ... Note The keyring_encrypted_file plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-file-plugin.html
The keyring_file plugin supports the functions that comprise the standard MySQL Keyring service interface. Keyring operations performed by those functions are accessible at two levels: SQL interface: In SQL statements, call the functions described ... The keyring_file keyring plugin stores keyring data in a file local to the server ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
Each row in this table corresponds to a table being replicated, determines how to log changes to the table and, if a conflict resolution function is specified, and determines how to resolve conflicts for that table. conflict_fn column The conflict ... ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated and in the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids.html
The auto-positioning function for synchronizing a replica and source that use GTIDs (see Section 16.1.3.3, “GTID Auto-Positioning”). Stored functions that you can use to work with GTIDs (see Section 16.1.3.7, “Stored Function Examples to ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-scaleout.html
Start by creating a wrapper library or module that implements the following functions: safe_writer_connect() safe_reader_connect() safe_reader_statement() safe_writer_statement() safe_ in each function name means that the function takes care of ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-code.html
A similar statement, SHOW FUNCTION CODE, displays information about stored functions (see Section 13.7.5.19, “SHOW FUNCTION CODE Statement”). SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
Banks, for example, use stored procedures and functions for all common operations. Stored routines also enable you to have libraries of functions in the database server. Additional Resources You may find the Stored Procedures User Forum of use when ...A stored routine is a set of SQL statements that can be stored in the ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
To solve the dilemma of whether or not to push down conditions into the subquery, the conditions are wrapped within “trigger” functions. AND trigcond(oe_N=ie_N) ) Each trigcond(X) is a special function that evaluates to the following values: X ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
--binary-as-hex when enabled affects display of all binary strings, including those returned by functions such as CHAR() and UNHEX(). By default, mysql translates \r\n in statement strings to \n and interprets \0 as the statement terminator. mysql ...