PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/drop-user.html
The DROP USER statement removes one or more MySQL accounts and their privileges. It removes privilege rows for the account from all grant tables. To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/drop-view.html
If any views named in the argument list do not exist, the statement returns an error indicating by name which nonexisting views it was unable to drop, but also drops all views in the list that do exist. Note In MySQL 8.0, DROP VIEW fails if any ...
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-installation.html
MySQL Enterprise Encryption functions are located in a loadable function library file installed in the plugin directory (the directory named by the plugin_dir system variable). The function library base name is openssl_udf and the suffix is ...
https://dev.mysql.com/doc/refman/5.7/en/error-creating-innodb.html
The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations when a DML or DDL statement fails due to problems at the file system level. Initialization Problems ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-syslog.html
It is possible to have mysqld write the error log to the system log (the Event Log on Windows, and syslog on Unix and Unix-like systems). To do so, use these system variables: log_syslog: Enable this variable to send the error log to the system log. (On Windows, log_syslog is enabled by default.) If log_syslog is enabled, the following system variables can also be used for finer ...
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/execute.html
EXECUTE stmt_name [USING @var_name [, @var_name] ...] After preparing a statement with PREPARE, you execute it with an EXECUTE statement that refers to the prepared statement name. If the prepared statement contains any parameter markers, you must ...
https://dev.mysql.com/doc/refman/5.7/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-information-schema.html
Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. Where can I find the ANSI SQL 2003 specification for INFORMATION_SCHEMA? A.7.4. What is the difference between the Oracle Data Dictionary and MySQL INFORMATION_SCHEMA? ...