PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/install-component.html
Subqueries, stored functions, and aggregate functions are not permitted as part of the value expression. [SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} [component_prefix.]system_var_name | {PERSIST | @@PERSIST.} ...
https://dev.mysql.com/doc/refman/8.0/en/key-space.html
Numbers are stored with the high byte first, so this helps when you have many integer keys that have an identical prefix. You can roughly calculate the size for the index file as (key_length+4)/0.67, summed over all keys. This is for the worst case ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-key-types.html
Example keyring operations involving the SECRET key type: SELECT keyring_key_generate('MySecret1', 'SECRET', 20); SELECT keyring_key_remove('MySecret1'); SELECT keyring_key_store('MySecret2', 'SECRET', 'MySecretData'); SELECT ... MySQL Keyring ...
https://dev.mysql.com/doc/refman/8.0/en/leave.html
If the label is for the outermost stored program block, LEAVE exits the program. LEAVE label This statement is used to exit the flow control construct that has the given label.
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html
A password for the superuser is set and stored in the error log file. The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by Oracle. There are two sources for obtaining them, for the Community ...
https://dev.mysql.com/doc/refman/8.0/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.0/en/making-windows-dumps.html
Program Database files (with suffix pdb) are included in the ZIP Archive Debug Binaries & Test Suite distribution of MySQL. These files provide information for debugging your MySQL installation in the event of a problem. This is a separate download ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT value. ABS(X) Returns the absolute value of X, or NULL if X is NULL. mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); ...
https://dev.mysql.com/doc/refman/8.0/en/mrr-optimization.html
Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's cache. With the Disk-Sweep Multi-Range Read (MRR) optimization, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-tables.html
The litter date of the mother is in the event table, but to calculate her age on that date you need her birth date, which is stored in the pet table. The pet table keeps track of which pets you have. If you want to record other information about ...