MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 41 to 50 of 71 total results

11.1.4 Floating-Point Types (Approximate Value) - FLOAT, DOUBLE

https://dev.mysql.com/doc/refman/5.7/en/floating-point-types.html

Here, (M,D) means than values can be stored with up to M digits in total, of which D digits may be after the decimal point. The FLOAT and DOUBLE types represent approximate numeric data values. MySQL uses four bytes for single-precision values and ...

14.6.2.4 InnoDB Full-Text Indexes

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

For example, in the auxiliary table name test/FTS_0000000000000147_00000000000001c9_INDEX_1, the hex value 1c9 has a decimal value of 457. Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and ...

B.3.3.1 Problems with File Permissions

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

For example, setting UMASK=0600 is equivalent to UMASK=384 because 0600 octal is 384 decimal. If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld starts. For example, mysqld ...

3.6 Examples of Common Queries

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

Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per ...

12.8.2 Regular Expressions

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

Table 12.14 Regular Expression Functions and Operators Name Description NOT REGEXP Negation of REGEXP REGEXP Whether string matches regular expression RLIKE Whether string matches regular expression A regular expression is a powerful way of ...

4.9 Environment Variables

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

For example, setting UMASK=0600 is equivalent to UMASK=384 because 0600 octal is 384 decimal. This section lists environment variables that are used directly or indirectly by MySQL. Most of these can also be found in other places in this manual.

12.16.11 Spatial GeoJSON Functions

https://dev.mysql.com/doc/refman/5.7/en/spatial-geojson-functions.html

max_dec_digits, if specified, limits the number of decimal digits for coordinates and causes rounding of output. This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are ...

26.4.4.22 The ps_trace_statement_digest() Procedure

https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-statement-digest.html

in_interval DECIMAL(2,2): The analysis interval in seconds (which can be fractional) at which to try to take snapshots. Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the ...

11.2.3 The TIME Type

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

The only delimiter recognized between a time part and a fractional seconds part is the decimal point. MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large ...

23.3.1 Trigger Syntax and Examples

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

To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER Statement”. Here is a simple example that associates a ...

Displaying 41 to 50 of 71 total results