PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/adding-collation.html
Some of these can be added to MySQL without recompiling: Simple collations for 8-bit character sets. Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. As of MySQL 8.0.33, ...
https://dev.mysql.com/doc/refman/8.0/en/alter-logfile-group.html
(Bug #13116514, Bug #16104705, Bug #62858) On 32-bit systems, the maximum supported value for INITIAL_SIZE is 4294967296 (4 GB). ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This ...
https://dev.mysql.com/doc/refman/8.0/en/alter-tablespace.html
On 32-bit systems, the maximum supported value for INITIAL_SIZE is 4294967296 (4 GB). It can be used to add a new data file to, or to drop a data file from an NDB tablespace. It can also be used to rename an NDB Cluster Disk Data tablespace, rename ...
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...
https://dev.mysql.com/doc/refman/8.0/en/calculating-days.html
The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web page. CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-set.html
For example: _binary 'a' The _binary introducer is permitted for hexadecimal literals and bit-value literals as well, but unnecessary; such literals are binary strings by default. The binary character set is the character set for binary strings, ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-ucs2.html
The ucs2 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Uses a fixed-length 16-bit encoding and requires two bytes per character. Note The ucs2 character set is deprecated in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/choosing-types.html
This enables you to do all calculations with 64-bit integers and then convert results back to floating-point values as necessary. For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html
For example, if the donor instance runs on a Linux 64-bit platform, the recipient instance must also run on that platform. The clone plugin supports the following syntax for cloning remote data; that is, cloning data from a remote MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
Each NULL column takes one bit extra, rounded up to the nearest byte. This section describes limits on the number of columns in tables and the size of individual rows. Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of ...