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/ddl-log.html
There are no user-configurable server options or variables associated with this file. The DDL log, or metadata log, records metadata operations generated by data definition statements affecting table partitioning, such as ALTER TABLE t3 DROP ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
For example, the following statement finds rows matching the WHERE clause, sorts them by timestamp_column, and deletes the first (oldest) one: DELETE FROM somelog WHERE user = 'jcole' ORDER BY timestamp_column LIMIT 1; ORDER BY also helps to delete ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/5.7/en/deploy-mysql-nonlinux-docker.html
Other platforms are not supported, and users running the MySQL Docker images from Oracle on them are doing so at their own risk. Warning The MySQL Docker images provided by Oracle are built specifically for Linux platforms. This section discusses ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
The optimizer handles derived tables and view references the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution plans.
https://dev.mysql.com/doc/refman/5.7/en/downgrading.html
Note In the following discussion, MySQL commands that must be run using a MySQL account with administrative privileges include -u root on the command line to specify the MySQL root user. This section describes the steps to downgrade a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to perform. Use the private key to encrypt data and the public key to decrypt it This requires that the members of the key ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
For example, this CREATE TABLE statement does not work because the CONCAT function cannot be used to construct an enumeration value: CREATE TABLE sizes ( size ENUM('small', CONCAT('med','ium'), 'large') ); You also cannot employ a user variable as ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
https://dev.mysql.com/doc/refman/5.7/en/error-interfaces.html
The client may display the error message so the user can take corrective measures, internally attempt to resolve or retry a failed operation, or take other action. Error messages can originate on the server side or the client side, and each error ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
As just illustrated, the client may display the error message so the user can take corrective measures. This section discusses how error messages originate within MySQL and the elements they contain. Error Message Sources Error Message Elements ...
https://dev.mysql.com/doc/refman/5.7/en/events-syntax.html
An event can be dropped by any user having the EVENT privilege for the database on which the event is defined. MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. The ...