PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/start-slave.html
The option cannot be set to an empty or null string. START SLAVE [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-implementations.html
Example: "U+0000 NULL" does not have a weight and is ignorable. mysql> SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'; Query OK, 0 rows affected (0.05 sec) mysql> SELECT HEX('a'), HEX(WEIGHT_STRING('a')); +----------+-------------------------+ | ...
https://dev.mysql.com/doc/refman/5.7/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-quick.html
To familiarize you with the basics, we describe the simplest possible configuration for a functional NDB Cluster. After this, you should be able to design your desired setup from the information provided in the other relevant sections of this ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-subqueries.html
Development is ongoing, so no optimization tip is reliable for the long term. The following list provides some interesting tricks that you might want to play with. See also Section 8.2.2, “Optimizing Subqueries, Derived Tables, and View ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-pre-filtering.html
Generally, the effect is to reset the summary columns to 0 or NULL, not to remove rows. Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Pre-filtering can be applied to either the producer or ...
https://dev.mysql.com/doc/refman/5.7/en/row-subqueries.html
The expression is unknown (that is, NULL) if the subquery produces no rows. Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that returns a single row and can thus return more than one ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
This can have values A (ascending), D (descending), or NULL (not sorted). That is, the number of indexed characters if the column is only partly indexed, NULL if the entire column is indexed. However, prefix lengths for index specifications in ...
https://dev.mysql.com/doc/refman/5.7/en/gis-format-conversion-functions.html
There are also functions to convert a string from WKT or WKB format to internal geometry format. ST_AsText(g), ST_AsWKT(g) Converts a value in internal geometry format to its WKT representation and returns the string result. mysql> SET @g = ...