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/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
The server creates the file in the data directory unless an absolute path name is given to specify a different directory. Administrative statements include ALTER TABLE, ANALYZE TABLE, CHECK TABLE, CREATE INDEX, DROP INDEX, OPTIMIZE TABLE, and REPAIR ... The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-analysis-functions.html
MySQL provides functions to perform various operations on spatial data.
https://dev.mysql.com/doc/refman/8.0/en/spatial-convenience-functions.html
Given two points pt1 and pt2, ST_MakeEnvelope() creates the result geometry on an abstract plane like this: If pt1 and pt2 are equal, the result is the point pt1. According to Boost.Geometry, geometries might become invalid as a result of the ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html
The string might be shorter than max_length characters because the algorithm that creates the geohash value continues until it has created a string that is either an exact representation of the location or max_length characters, whichever comes ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-reference-systems.html
To enable manipulation of SRS entries stored in the data dictionary, MySQL provides these SQL statements: CREATE SPATIAL REFERENCE SYSTEM: See Section 15.1.19, “CREATE SPATIAL REFERENCE SYSTEM Statement”. A spatial reference system (SRS) for ...
https://dev.mysql.com/doc/refman/8.0/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a subquery: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); In this example, SELECT * ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links.html
For InnoDB tables, use the DATA DIRECTORY clause of the CREATE TABLE statement instead of symbolic links, as explained in Section 17.6.1.2, “Creating Tables Externally”. You can move databases or tables from the database directory to other ...
https://dev.mysql.com/doc/refman/8.0/en/sys-diagnostics.html
Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a restricted operation, so the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-processlist.html
tmp_tables The number of internal in-memory temporary tables created by the current statement. tmp_disk_tables The number of internal on-disk temporary tables created by the current statement. The MySQL process list indicates the operations ...