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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. UPDATE is a DML statement that modifies rows in a table. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
These functions permit the server's list of version tokens to be created, changed, removed, and inspected: version_tokens_set() completely replaces the current list and assigns a new list. Before using Version Tokens, install it according to the ...
https://dev.mysql.com/doc/refman/5.7/en/view-metadata.html
To obtain metadata about views: Query the VIEWS table of the INFORMATION_SCHEMA database.