MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 61 to 67 of 67 total results

« Previous
5
6
7
Next »

14.9.1 Natural Language Full-Text Searches

https://dev.mysql.com/doc/refman/8.0/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 ...

14.9.2 Boolean Full-Text Searches

https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html

The difference is due to how the casts between integers and floats/doubles are performed internally by InnoDB (along with related precision and rounding decisions), and how they are performed elsewhere, such as in the MySQL command-line client or ...

14.6 Numeric Functions and Operators

https://dev.mysql.com/doc/refman/8.0/en/numeric-functions.html

Table 14.8 Numeric Functions and Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator ABS() Return the absolute value ACOS() Return ...

1.2.2 The Main Features of MySQL

https://dev.mysql.com/doc/refman/8.0/en/features.html

Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. This section describes some ...

13.1 Numeric Data Types

https://dev.mysql.com/doc/refman/8.0/en/numeric-types.html

These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, and DOUBLE PRECISION). MySQL also treats REAL as a synonym for DOUBLE PRECISION (a nonstandard ...

13.9 Using Data Types from Other Database Engines

https://dev.mysql.com/doc/refman/8.0/en/other-vendor-data-types.html

To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...

14.16.7.4 Polygon and MultiPolygon Property Functions

https://dev.mysql.com/doc/refman/8.0/en/gis-polygon-property-functions.html

Functions in this section return properties of Polygon or MultiPolygon values. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, ...