PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. Derived tables and common table expressions can also be specified in multiple-table UPDATE and DELETE statements, but can only be ...That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-general.html
Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? A.1.3. Which version of MySQL is production-ready (GA)? MySQL 9.6, 8.4, and 8.0 are actively supported for production use. It became a bugfix series as of MySQL 8.0.34 ...
https://dev.mysql.com/doc/refman/8.0/en/windows-restrictions.html
This is because the physical address limit on Windows 32-bit is 4GB and the default setting within Windows is to split the virtual address space between kernel (2GB) and user/applications (2GB). Some versions of Windows have a boot time setting to ... The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-switch.html
Each MySQL replica (Replica 1, Replica 2, and Replica 3) is a replica running with binary logging enabled, and with --log-slave-updates=OFF. The replica does not check whether the databases on the source are compatible with those on the replica; it ... You can tell a replica to change to a new source using the CHANGE REPLICATION SOURCE TO statement (prior to MySQL 8.0.23: CHANGE MASTER ...
https://dev.mysql.com/doc/refman/8.0/en/charset-general.html
In real life, most character sets have many characters: not just A and B but whole alphabets, sometimes multiple alphabets or eastern writing systems with thousands of characters, along with many special symbols and punctuation marks. A character ...A collation is a set of rules for comparing characters in a character ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-acid.html
The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical applications. MySQL includes components such as the InnoDB storage engine that adhere closely to ...In cases where you have additional software safeguards, ultra-reliable hardware, or an application that can tolerate a small amount of data loss or inconsistency, you can adjust MySQL settings to trade some of the ACID reliability for greater performance or ...
https://dev.mysql.com/doc/refman/8.0/en/charset.html
MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of collations. The default MySQL server character set and collation are utf8mb4 and ...If you want ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature-windows.html
You may use a different tool but our examples are based on Gpg4win, and utilize its bundled Kleopatra GUI. Type "Mysql Release Engineering" into the search box and press Search. The Fingerprint and Key-ID must be "3A79BD29" for MySQL 8.0.28 and ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-tablespace-encryption.html
What data types and data lengths does InnoDB data-at-rest encryption support? A.17.7. InnoDB data-at-rest encryption provides the benefit of encryption without the overhead associated with traditional database encryption solutions, which would ...Is ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-functional-dependence.html
The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally dependent on X. A UNIQUE index over a NOT NULL column could be used instead of a primary key and the same functional ... The following discussion provides several examples of the ways in which MySQL detects functional ...