MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 71 to 80 of 83 total results

12.9.1 Natural Language Full-Text Searches

https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html

By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text collection. A collection is a set of one or more columns included in a FULLTEXT index. For each row in the ...

12.9 Full-Text Search Functions

https://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html

MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A ...

16.1.3.7 Stored Function Examples to Manipulate GTIDs

https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html

This section provides examples of stored functions (see Chapter 23, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID ...

13.2.4 HANDLER Statement

https://dev.mysql.com/doc/refman/5.7/en/handler.html

HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ... ] HANDLER tbl_name READ index_name { FIRST | NEXT | PREV | LAST } [ WHERE where_condition ] [LIMIT ...

12.17.1 JSON Function Reference

https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html

Table 12.22 JSON Functions Name Description Introduced Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...

3.3.3 Loading Data into a Table

https://dev.mysql.com/doc/refman/5.7/en/loading-tables.html

Suppose that your pet records can be described as shown here. You could create a text file pet.txt containing one record per line, with values separated by tabs, and given in the order in which the columns were listed in the CREATE TABLE statement.

4.5.1.3 mysql Client Logging

https://dev.mysql.com/doc/refman/5.7/en/mysql-logging.html

The mysql client can do these types of logging for statements executed interactively: On Unix, mysql writes the statements to a history file. By default, this file is named .mysql_history in your home directory. To specify a different file, set the ...

1.3 What Is New in MySQL 5.7

https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html

This section summarizes what has been added to, deprecated in, and removed from MySQL 5.7. A companion section lists MySQL server options and variables that have been added, deprecated, or removed in MySQL 5.7; see Section 1.4, “Server and Status ...

2.3.3.5 MySQL Installer Console Reference

https://dev.mysql.com/doc/refman/5.7/en/MySQLInstallerConsole.html

MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL Installer. This reference includes: MySQL Product Names Command Syntax Command Actions The console is installed when MySQL Installer is initially executed and ...

4.2.2.2 Using Option Files

https://dev.mysql.com/doc/refman/5.7/en/option-files.html

Most MySQL programs can read startup options from option files (sometimes called configuration files). Option files provide a convenient way to specify commonly used options so that they need not be entered on the command line each time you run a ...

Displaying 71 to 80 of 83 total results