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/subqueries.html
Here is an example of a subquery: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); In this example, SELECT * FROM t1 ... is the outer query (or outer statement), and (SELECT column1 FROM t2) is the subquery. A subquery can contain many of ...All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are ...
https://dev.mysql.com/doc/refman/5.7/en/all-subqueries.html
Thus, these two statements are the same: SELECT s1 FROM t1 WHERE s1 <> ALL (SELECT s1 FROM t2); SELECT s1 FROM t1 WHERE s1 NOT IN (SELECT s1 FROM t2); . The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three ...
https://dev.mysql.com/doc/refman/5.7/en/bit-functions.html
mysql> SELECT 1 ^ 1; -> 0 mysql> SELECT 1 ^ 0; -> 1 mysql> SELECT 11 ^ 3; -> 8 << Shifts a longlong (BIGINT) number to the left. mysql> SELECT 1 << 2; -> 4 >> Shifts a longlong (BIGINT) number to the right. mysql> SELECT 4 >> 2; -> 1 ~ Invert all ...
https://dev.mysql.com/doc/refman/5.7/en/charset-literal.html
For the simple statement SELECT 'string', the string has the connection default character set and collation defined by the character_set_connection and collation_connection system variables. Examples: SELECT 'abc'; SELECT _latin1'abc'; SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html
This can be a simple statement such as SELECT or INSERT, or a compound statement written using BEGIN and END. This prohibition includes SELECT statements that do not have an INTO var_list clause and other statements such as SHOW, EXPLAIN, and CHECK ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html
You cannot test them as NULL values in join conditions or the WHERE clause to determine which rows to select. A MySQL extension permits a column that does not appear in the GROUP BY list to be named in the select list. The GROUP BY clause permits a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-import.html
Overrides entries in NDB_CONNECTSTRING and my.cnf ADDED: NDB 7.6.2 --ndb-mgmd-host=connection_string, -c connection_string Same as --ndb-connectstring ADDED: NDB 7.6.2 --ndb-nodeid=# Set node ID for this node, overriding any ID set by ... ndb_import ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
--exclude-missing-columns Command-Line Format --exclude-missing-columns It is possible to restore only selected table columns using this option, which causes ndb_restore to ignore any columns missing from tables being restored as compared to the ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-simplification.html
This results in a query with no outer joins at all: SELECT * FROM (T1 INNER JOIN T2 ON T2.A=T1.A), T3 WHERE T3.C > 0 AND T3.B=T2.B Sometimes the optimizer succeeds in replacing an embedded outer join operation, but cannot convert the embedding outer ... Table expressions in the FROM clause of a query are simplified in many ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-examples.html
That is, for two numbers X1 and X2 that have scale S1 and S2, the scale of the result is S1 + S2: mysql> SELECT .01 * .01; +-----------+ | .01 * .01 | +-----------+ | 0.0001 | +-----------+ Example 3. A value with a fractional part exactly half way ... This section provides some examples that show precision math query results in ...