PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/dbug-package.html
The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. When you have configured MySQL for debugging, this package makes it possible to get a trace file of what the program is doing. This section ...
https://dev.mysql.com/doc/refman/5.7/en/declare-local-variable.html
type [DEFAULT value] This statement declares local variables within stored programs. To provide a default value for a variable, include a DEFAULT clause. The value can be specified as an expression; it need not be a constant. If the DEFAULT clause ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-concepts.html
CRUD Operations Create, Read, Update and Delete (CRUD) operations are the four basic operations that can be performed on a database Collection or Table. In terms of MySQL this means: Create a new entry (insertion or addition) Read entries (queries) ... This section explains the concepts introduced as part of using MySQL as a document ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-troubleshooting.html
After downgrading, reload the dump file using mysql or mysqlimport to re-create your tables. Dump any tables that were inaccessible to the older server by using mysqldump to create a dump file. If you downgrade from one release series to another, ...
https://dev.mysql.com/doc/refman/5.7/en/drop-function-loadable.html
(DROP FUNCTION is also used to drop stored functions; see Section 13.1.27, “DROP PROCEDURE and DROP FUNCTION Statements”.) DROP FUNCTION is the complement of CREATE FUNCTION. Note To upgrade the shared library associated with a loadable ... DROP ...
https://dev.mysql.com/doc/refman/5.7/en/drop-logfile-group.html
(For information on creating log file groups, see Section 13.1.15, “CREATE LOGFILE GROUP Statement”.) Important Before dropping a log file group, you must drop all tablespaces that use that log file group for UNDO logging. DROP LOGFILE GROUP ...
https://dev.mysql.com/doc/refman/5.7/en/drop-server.html
Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. Dynamic format is a little more complex than static ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-function-reference.html
Table 6.36 MySQL Enterprise Encryption Functions Name Description asymmetric_decrypt() Decrypt ciphertext using private or public key asymmetric_derive() Derive symmetric key from asymmetric keys asymmetric_encrypt() Encrypt cleartext using private ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-rotation.html
For example, assuming a log file name of host_name.err, use the following commands to rename the file and create a new one: mv host_name.err host_name.err-old mysqladmin flush-logs error mv host_name.err-old backup-directory On Windows, use rename ... If you flush the error log using a FLUSH ERROR LOGS or FLUSH LOGS statment, or a mysqladmin flush-logs command, the server closes and reopens any error log file to which it is ...