MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 61 to 70 of 71 total results

https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-python-documents-collections.html

When you are using MySQL as a Document Store, collections are containers within a schema that you can create, list, and drop. Collections contain JSON documents that you can add, find, update, and remove. The examples in this section use the ...

14.9.1 Natural Language Full-Text Searches

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

14.9.2 Boolean Full-Text Searches

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

13.1.7 Out-of-Range and Overflow Handling

https://dev.mysql.com/doc/refman/9.7/en/out-of-range-and-overflow.html

When a floating-point or fixed-point column is assigned a value that exceeds the range implied by the specified (or default) precision and scale, MySQL stores the value representing the corresponding endpoint of that range. If no restrictive modes ...

26.2.3 COLUMNS Partitioning

https://dev.mysql.com/doc/refman/9.7/en/partitioning-columns.html

(This is the same as with partitioning by RANGE and LIST.) Other numeric data types (such as DECIMAL or FLOAT) are not supported as partitioning columns. The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST ...

26.6.3 Partitioning Limitations Relating to Functions

https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-functions.html

This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...

Displaying 61 to 70 of 71 total results