PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/examples.html
Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/doc/refman/5.7/en/federated-description.html
When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated data. When you create a FEDERATED table, the table definition is the same, but the ...A ...
https://dev.mysql.com/doc/refman/5.7/en/gis-format-conversion-functions.html
See Section 12.16.3, “Functions That Create Geometry Values from WKT Values”, and Section 12.16.4, “Functions That Create Geometry Values from WKB Values”. MySQL supports the functions listed in this section for converting geometry values ...