PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
DROP DATABASE has no effect in this regard, even if the operation drops all tables belonging to the tablespace. A DROP DATABASE operation can drop tables that belong to a general tablespace but it cannot drop the tablespace, even if the operation ...
https://dev.mysql.com/doc/refman/5.7/en/drop-user.html
To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql system database. 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/5.7/en/entering-queries.html
Doing so does not in itself select any database to work with, but that is okay. Normally, column labels are the names of the columns you fetch from database tables. Make sure that you are connected to the server, as discussed in the previous ...
https://dev.mysql.com/doc/refman/5.7/en/error-creating-innodb.html
If you already created some InnoDB tables, also delete the corresponding .frm files for these tables, and any .ibd files if you are using multiple tablespaces, from the MySQL database directories. The troubleshooting steps for InnoDB I/O problems ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
These indicate issues of interest to database administrators or that require DBA action. It is MySQL-specific and is not portable to other database systems. This section discusses how error messages originate within MySQL and the elements they ...
https://dev.mysql.com/doc/refman/5.7/en/events-metadata.html
To obtain metadata about events: Query the event table of the mysql database. Event Scheduler Time Representation Each session in MySQL has a session time zone (STZ). This is the session time_zone value that is initialized from the server's global ...
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/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. Here are some examples: If you run multiple servers that use the same database directory (not recommended), each server must ...External locking is used in situations where a single process such as the MySQL server cannot be assumed to be the only process that requires access to ...
https://dev.mysql.com/doc/refman/5.7/en/federated-description.html
A FEDERATED table consists of two elements: A remote server with a database table, which in turn consists of the table definition (stored in the .frm file) and the associated table. A local server with a database table, where the table definition ...
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
The reason for this is that this table must work like a data file that would never be written to by anything other than the database system. The integrity of the data in the local table could be breached if there was any change to the remote ...The ...