PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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. mysql> SELECT ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL ...It ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
To determine the current global or session sql_mode setting, select its value: SELECT @@GLOBAL.sql_mode; SELECT @@SESSION.sql_mode; Important SQL mode and user-defined partitioning. mysql> SET sql_mode = ''; mysql> SELECT NOT 1 BETWEEN -5 AND 5; -> ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html
mysql> SELECT 'David!' LIKE 'David_'; -> 1 mysql> SELECT 'David!' LIKE '%D%v%'; -> 1 To test for literal instances of a wildcard character, precede it by the escape character. mysql> SELECT 10 LIKE '1%'; -> 1 MySQL attempts in such cases to perform ... Table 12.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the resulting string is also a binary ...
https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
mysql> SELECT 1+'1'; -> 2 mysql> SELECT CONCAT(2,' test'); -> '2 test' It is also possible to convert a number to a string explicitly using the CAST() function. mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, ... When an ...
https://dev.mysql.com/doc/refman/5.7/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
For example, a subquery in a SELECT statement FROM clause is a derived table: SELECT ... This does not work: SELECT AVG(SUM(column1)) FROM t1 GROUP BY column1; However, this query provides the desired information: SELECT AVG(sum_column1) FROM ... A ...
https://dev.mysql.com/doc/refman/5.7/en/user-variables.html
This does not currently include contexts that explicitly require a literal value, such as in the LIMIT clause of a SELECT statement, or the IGNORE N LINES clause of a LOAD DATA statement. For example, to increment a variable, this is okay: SET @a = ... You can store a value in a user-defined variable in one statement and refer to it later in another ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-general-purpose.html
The following call creates a 2,048-bit DSA-encrypted key named MyKey: mysql> SELECT keyring_key_generate('MyKey', 'DSA', 256); +-------------------------------------------+ | keyring_key_generate('MyKey', 'DSA', 256) | ... MySQL Server supports a ...
https://dev.mysql.com/doc/refman/5.7/en/logical-operators.html
For example, the following statements all assess to TRUE: mysql> SELECT 10 IS TRUE; -> 1 mysql> SELECT -10 IS TRUE; -> 1 mysql> SELECT 'string' IS NOT NULL; -> 1 NOT, ! Logical NOT. mysql> SELECT NOT 10; -> 0 mysql> SELECT NOT 0; -> 1 mysql> SELECT ... Table 12.5 Logical Operators Name Description AND, && Logical AND NOT, ! Negates value OR, || Logical OR XOR Logical XOR In SQL, all logical operators evaluate to TRUE, FALSE, or NULL ...