PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-features-reserved-words.html
Replication can fail in such cases with Error 1064 You have an error in your SQL syntax..., even if a database or table named using the reserved word or a table having a column named using the reserved word is excluded from replication. In any SQL ... You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of identifiers on the source that are reserved words in the newer MySQL version running on the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-general.html
Does MySQL 5.7 have a Query Cache? Does it work on Server, Instance or Database? A.1.5. Which version of MySQL is production-ready (GA)? MySQL 9.4, 8.4, and 8.0 are actively supported for production use. MySQL 8.0 achieved General Availability (GA) ...Does MySQL have a NOW() function with fractions of seconds? ...
https://dev.mysql.com/doc/refman/5.7/en/example-storage-engine.html
When you create an EXAMPLE table, the server creates a table format file in the database directory. mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 sec) mysql> INSERT INTO test VALUES(1),(2),(3); ERROR 1031 ...To ... The EXAMPLE storage engine is a stub engine that does ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-view-changes.html
Figure 17.10 Stable Group View Change: a Member Joins Whenever a new member joins the group and therefore a view change is performed, every online server queues a view change log event for execution. This is queued because before the view change, ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-foreign-keys.html
When performing foreign key checks, InnoDB sets shared row-level locks on child or parent records that it must examine. row *************************** Table: shirt Create Table: CREATE TABLE `shirt` ( `id` smallint(5) unsigned NOT NULL ...For ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-functions.html
The following example shows how to convert the result of gen_rnd_email() to the utf8mb4 character set: SET @email = CONVERT(gen_rnd_email() USING utf8mb4); It may also be necessary to convert string arguments, as illustrated in Using Masked Data for ...If a string return value should be in a different character set, convert ...If a MySQL Enterprise Data Masking and De-Identification function is invoked from within the mysql client, binary string results ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-processes.html
For other types of API nodes, it is the name of the executable program connected to the cluster; NDB API applications can set a custom value for this using Ndb_cluster_connection::set_name(). By default, API nodes other than SQL nodes use ndb:// for ... This table contains information about NDB Cluster node processes; each node is represented by the row in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-api.html
DefaultHashMapSize: Set size (in buckets) to use for table hash maps. HeartbeatThreadPriority: Set heartbeat thread policy and priority for API nodes; see manual for allowed values. The listing in this section provides information about parameters ...AutoReconnect: Specifies whether an API node should reconnect fully when disconnected from ...
https://dev.mysql.com/doc/refman/5.7/en/non-typed-operators.html
5.7.13 / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) = Equal operator ^ Bitwise XOR AND, && Logical AND BETWEEN ... ->> Return value from JSON column after ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
Ideally, the value should be large enough for the entire result set to fit in the sort buffer (to avoid writes to disk and merge passes), but at minimum the value must be large enough to accommodate 15 tuples. This section describes when MySQL can ...An ORDER BY with and without LIMIT may return rows in different orders, as discussed in Section 8.2.1.17, “LIMIT Query ...