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/mysql-cluster-ndbd-definition.html
Data Memory, Index Memory, and String Memory DataMemory and IndexMemory are [ndbd] parameters specifying the size of memory segments used to store the actual records and their indexes. StringMemory Version (or later) NDB 7.5.0 Type or units % or ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
With this modifier, certain characters have special meaning at the beginning or end of words in the search string. Specify the search words within a double-quoted string immediately before the @distance operator, for example, MATCH(col1) ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
For example, to delete rows that exist in t1 that have no match in t2, use a LEFT JOIN: DELETE t1 FROM t1 LEFT JOIN t2 ON t1.id=t2.id WHERE t2.id IS NULL; The syntax permits .* after each tbl_name for compatibility with Access. DELETE is a DML ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name ...
https://dev.mysql.com/doc/refman/5.7/en/truncate-table.html
TRUNCATE TABLE can be used with Performance Schema summary tables, but the effect is to reset the summary columns to 0 or NULL, not to remove rows. Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
--binlog-do-db=db_name Command-Line Format --binlog-do-db=name Type String This option affects binary logging in a manner similar to the way that --replicate-do-db affects replication. --binlog-ignore-db=db_name Command-Line Format ... Startup ...
https://dev.mysql.com/doc/refman/5.7/en/create-user.html
The plugin name can be a quoted string literal or an unquoted name. An 'auth_string' value specifies account credentials, either as a cleartext (unencrypted) string or hashed in the format expected by the authentication plugin associated with the ...
https://dev.mysql.com/doc/refman/5.7/en/loading-tables.html
Suppose that Diane gets a new hamster named “Puffball.” You could add a new record using an INSERT statement like this: mysql> INSERT INTO pet VALUES ('Puffball','Diane','hamster','f','1999-03-30',NULL); String and date values are specified as ...For missing values (such as unknown sexes or death dates for animals that are still living), you can use NULL ...
https://dev.mysql.com/doc/refman/5.7/en/gis-mysql-specific-functions.html
If any argument does not represent a LinearRing (that is, not a closed and simple LineString), the return value is NULL. If any argument is not a proper WKB or geometry representation of the proper object type, the return value is NULL. MySQL ...