PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/user-variables.html
(This is the same coercibility as for table column values.) Hexadecimal or bit values assigned to user variables are treated as binary strings. To assign a hexadecimal or bit value as a number to a user variable, use it in numeric context. You can ...
https://dev.mysql.com/doc/refman/9.7/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. The MySQL 9.7 server ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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; expect it ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 ...