MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 421 to 430 of 506 total results

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

MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type. This chapter provides an overview and more detailed description of the properties of ...

13.2.1 Date and Time Data Type Syntax

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-syntax.html

(They convert the values to numbers, losing everything after the first nonnumeric character.) To work around this problem, convert to numeric units, perform the aggregate operation, and convert back to a temporal value. The date and time data types ...

13.2.2 The DATE, DATETIME, and TIMESTAMP Types

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

This section describes their characteristics, how they are similar, and how they differ. Be aware of certain properties of date value interpretation in MySQL: MySQL permits a “relaxed” format for values specified as strings, in which any ...

15.6.7.1 DECLARE ... CONDITION Statement

https://dev.mysql.com/doc/refman/8.0/en/declare-condition.html

SQLSTATE [VALUE] sqlstate_value: A 5-character string literal indicating an SQLSTATE value. DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... CONDITION ...

15.6.7.2 DECLARE ... HANDLER Statement

https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html

SQLSTATE [VALUE] sqlstate_value: A 5-character string literal indicating an SQLSTATE value, such as '42S01' to specify “unknown table”: DECLARE CONTINUE HANDLER FOR SQLSTATE '42S02' BEGIN -- body of handler END; Do not use SQLSTATE values that ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...

15.6.4.1 Local Variable DECLARE Statement

https://dev.mysql.com/doc/refman/8.0/en/declare-local-variable.html

Permissible characters and quoting rules are the same as for other identifiers, as described in Section 11.2, “Schema Object Names”. type [DEFAULT value] This statement declares local variables within stored programs. To provide a default value ...

10.2.1.5 Engine Condition Pushdown Optimization

https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html

In NDB 8.0.18 and later, columns can be compared with one another as long as they are of exactly the same type, including the same signedness, length, character set, precision, and scale, where these are applicable. This optimization improves the ...

13.3.5 The ENUM Type

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

Note that ENUM columns can be assigned a character set and collation. An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. See Section ...

18.8.3 FEDERATED Storage Engine Notes and Tips

https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html

When using a CONNECTION string, you cannot use an '@' character in the password. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The remote table that a ...

14.9 Full-Text Search Functions

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

There are no special operators, with the exception of double quote (") characters. MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE ...

Displaying 421 to 430 of 506 total results