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/using-mysqldump.html
As a source of data for experimentation: To make a copy of a database that you can use without changing the original data. This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and ...
https://dev.mysql.com/doc/refman/5.7/en/windows-installation-layout.html
include Include (header) files lib Libraries share Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation . Table 2.4 Default MySQL Installation Layout for Microsoft ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Supported Platforms Page compression requires sparse file and hole punching support. Hole Punch Size on Linux On Linux systems, the file system block size ...Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-aws-plugin.html
For any other region, you must also set keyring_aws_region explicitly in my.cnf. The keyring_aws keyring plugin communicates with the Amazon Web Services Key Management Service (AWS KMS) as a back end for key generation and uses a local file for key ... Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/limit-optimization.html
If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra data. If a filesort must be done, all rows that match the query without the LIMIT ...MySQL sometimes optimizes a query that has a LIMIT row_count clause and no HAVING clause: If you select only a few rows with LIMIT, MySQL uses indexes in some cases when normally it would prefer to do a full table ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
A warning is logged if you use this function when binlog_format is set to STATEMENT. mysql> SELECT ATAN(-2,2); -> -0.78539816339745 mysql> SELECT ATAN2(PI(),0); -> 1.5707963267949 CEIL(X) CEIL() is a synonym for CEILING(). mysql> SELECT ...ABS(X) ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions-mbr.html
A corresponding set of MBR functions defined according to the OpenGIS specification is described later in this section. mysql> SET @g1 = ST_GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))'); mysql> SET @g2 = ST_GeomFromText('Point(1 1)'); mysql> SELECT ... MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and ...
https://dev.mysql.com/doc/refman/5.7/en/condition-handling.html
Handlers can be defined for general conditions such as warnings or exceptions, or for specific conditions such as a particular error code. For information about how the server chooses handlers when a condition occurs, see Section 13.6.7.6, “Scope ... Conditions may arise during stored program execution that require special handling, such as exiting the current program block or continuing ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-like.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; The copy is created using the same version of the table storage ...
https://dev.mysql.com/doc/refman/5.7/en/drop-view.html
To avoid this failure scenario, use IF EXISTS syntax in DROP VIEW statements to prevent an error from occurring for views that do not exist. The IF EXISTS clause prevents an error from occurring for views that don't exist. When this clause is given, ...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 ...