PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. In addition, you can work in SQL with results from queries on tables in the INFORMATION_SCHEMA database, which you cannot easily ...The pattern is useful for restricting statement output to matching ...
https://dev.mysql.com/doc/refman/5.7/en/switchable-optimizations.html
Derived Table Merging Flags derived_merge (default on) Controls merging of derived tables and views into outer query block. The derived_merge flag controls whether the optimizer attempts to merge derived tables and view references into the outer ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
Only statements that modify databases or tables count against the update limit. An “account” in this context corresponds to a row in the mysql.user system table. That is, a connection is assessed against the User and Host values in the user ...
https://dev.mysql.com/doc/refman/5.7/en/copying-databases.html
For large tables, this is much faster than simply using mysqldump. After you import the mysql database on the new machine, execute mysqladmin flush-privileges so that the server reloads the grant table information. Note You can copy the .frm, .MYI, ... In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL ...
https://dev.mysql.com/doc/refman/5.7/en/correlated-subqueries.html
A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query. For example: SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2 WHERE t2.column2 = t1.column2); Notice that the subquery ...So, ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
You can do so by creating tables to hold your data and loading them with the desired information. Then you can answer different sorts of questions about your animals by retrieving data from the tables. Once you know how to enter SQL statements, you ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET'); -> '2004-01-01 13:00:00' mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00'); -> '2004-01-01 22:00:00' Note To use named time zones such as 'MET' or 'Europe/Amsterdam', the ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/5.7/en/example-storage-engine.html
When you create an EXAMPLE table, the server creates a table format file in the database directory. The file begins with the table name and has an .frm extension. mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-information-schema.html
Can I add to or otherwise modify the tables found in the INFORMATION_SCHEMA database? A.7.1. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? See Chapter 24, INFORMATION_SCHEMA Tables. What is the difference between the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-tablespace-encryption.html
Does the transportable tablespaces feature work with InnoDB data-at-rest encryption? A.17.12. How do I migrate data from a cleartext InnoDB tablespace to an encrypted InnoDB tablespace? A.17.16. It uses Electronic Codebook (ECB) block encryption ...