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/show-index.html
Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte character set. SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...
https://dev.mysql.com/doc/refman/5.7/en/show-profile.html
If LIMIT is given, OFFSET offset may be added to begin the output offset rows into the full set of rows. Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
For NDB tables, the output of this statement shows appropriate values for the Avg_row_length and Data_length columns, with the exception that BLOB columns are not taken into account. SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/show-warnings.html
mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> INSERT INTO t1 VALUES(10,'mysql'), (NULL,'test'), (300,'xyz'); Query OK, 3 rows affected, 3 warnings (0.00 sec) Records: 3 Duplicates: 0 Warnings: 3 ... SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current ...
https://dev.mysql.com/doc/refman/5.7/en/solaris-installation-pkg.html
The pkg installer copies a suitable startup script for MySQL into /etc/init.d/mysql. You can install MySQL on Solaris using a binary package of the native Solaris PKG format instead of the binary tarball distribution. Important The installation ...
https://dev.mysql.com/doc/refman/5.7/en/source-installation.html
We put a great deal of effort into ensuring that our binaries are built with the best possible options for optimal performance. Building MySQL from the source code enables you to customize build parameters, compiler optimizations, and installation ...
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
A geometry collection is processed by giving its components one by one to the simplification algorithm, and the returned geometries are put into a geometry collection as result. The functions in this section provide convenience operations on ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. Geohash values are strings that contain only characters chosen from "0123456789bcdefghjkmnpqrstuvwxyz". The functions in this section ...
https://dev.mysql.com/doc/refman/5.7/en/sql-replication-statements.html
Statements are split into a group which controls replication source servers, a group which controls replica servers, and a group which can be applied to any servers in a replication topology. Replication can be controlled through the SQL interface ...