PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/drop-logfile-group.html
(For information on creating log file groups, see Section 15.1.16, “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/8.0/en/drop-role.html
To use this statement, you must have the global DROP ROLE or CREATE USER privilege. As of MySQL 8.0.16, users who have the CREATE USER privilege can use this statement to drop accounts that are locked or unlocked. DROP ROLE removes one or more roles ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/drop-user.html
To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql system schema. DROP USER does not automatically drop or invalidate databases or objects within them that the old user created. The DROP USER ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/encrypted-connections.html
For information on how to require users to use encrypted connections, see the discussion of the REQUIRE clause of the CREATE USER statement in Section 15.7.1.3, “CREATE USER Statement”. With an unencrypted connection between the MySQL client ...
https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html
An example of such a query, using the table t1 created previously, is shown here: mysql> EXPLAIN -> SELECT * FROM t1 AS x -> LEFT JOIN t1 AS y -> ON x.a=0 AND y.b>=3\G *************************** 1. This optimization improves the efficiency of ...
https://dev.mysql.com/doc/refman/8.0/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 statement, 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/8.0/en/event-scheduler.html
Section 27.4.3, “Event Syntax”, discusses the SQL statements for creating, altering, and dropping MySQL Events. The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a schedule. The ...
https://dev.mysql.com/doc/refman/8.0/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 ...