MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 11 to 20 of 35 total results

12.4.2 Comparison Functions and Operators

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

To convert a value to a specific type for comparison purposes, you can use the CAST() function. If you use a string constant such as '2001-1-1' in a comparison to a DATE, cast the string to a DATE. Table 12.4 Comparison Operators Name Description > ...

12.1 Built-In Function and Operator Reference

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

The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...

1.6.2 MySQL Differences from Standard SQL

https://dev.mysql.com/doc/refman/5.7/en/differences-from-ansi.html

The CAST() function does not support cast to REAL or BIGINT. We try to make MySQL Server follow the ANSI SQL standard and the ODBC SQL standard, but MySQL Server performs operations differently in some cases: There are several differences between ...

12.7 Date and Time Functions

https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html

To ensure that the result is DATETIME, you can use CAST() to convert the first argument to DATETIME. If you want to subtract UNIX_TIMESTAMP() columns, you might want to cast them to signed integers. This section describes the functions that can be ...

9.4 User-Defined Variables

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

You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...

11.2.9 Conversion Between Date and Time Types

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

To perform the comparison by ignoring the time part of the DATETIME value instead, use the CAST() function in the following way: date_col = CAST(datetime_col AS DATE) Conversion of TIME and DATETIME values to numeric form (for example, by adding +0) ... To some extent, you can convert a value from one temporal type to ...

11.3.5 The ENUM Type

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

For example, you can retrieve numeric values from an ENUM column like this: mysql> SELECT enum_col+0 FROM tbl_name; Functions such as SUM() or AVG() that expect a numeric argument cast the argument to a number if necessary. Make sure that the column ... 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 ...

11.3.6 The SET Type

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

Functions such as SUM() or AVG() that expect a numeric argument cast the argument to a number if necessary. For SET values, the cast operation causes the numeric value to be used. A SET is a string object that can have zero or more values, each of ...

12.19.1 Aggregate Function Descriptions

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

Examples: SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(time_col))) FROM tbl_name; SELECT FROM_DAYS(SUM(TO_DAYS(date_col))) FROM tbl_name; Functions such as SUM() or AVG() that expect a numeric argument cast the argument to a number if necessary. For SET or ...

9.1.4 Hexadecimal Literals

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

Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase of the digits and of any leading X does not matter. A leading 0x is case-sensitive and cannot be written as 0X.

Displaying 11 to 20 of 35 total results