PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/spatial-analysis-functions.html
MySQL provides functions to perform various operations on spatial data.
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/en/spatial-types.html
The specification describes a set of SQL geometry types, as well as functions on those types to create and analyze geometry values. The other storage engines support non-SPATIAL indexes, as described in Section 13.1.14, “CREATE INDEX Statement”.
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-databases.html
On Unix, the way to symlink a database is first to create a directory on some disk where you have free space and then to create a soft link to it from the MySQL data directory. $> mkdir /dr1/databases/test $> ln -s /dr1/databases/test ...
https://dev.mysql.com/doc/refman/5.7/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 14.6.1.2, “Creating Tables Externally”. You can move databases or tables from the database directory to other ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-analysis.html
tmp_tables The total number of internal in-memory temporary tables created by occurrences of the statement. tmp_disk_tables The total number of internal on-disk temporary tables created by occurrences of the statement. The statement_analysis and ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-metadata.html
To obtain metadata about triggers: Query the TRIGGERS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/5.7/en/tutorial.html
This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. If you are interested only in accessing an existing database, you may want to skip the sections that describe ...mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the ...