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/case.html
[ELSE statement_list] END CASE The CASE statement for stored programs implements a complex conditional construct. This syntax cannot be used to test for equality with NULL because NULL = NULL is false. For the second syntax, each WHEN clause ...
https://dev.mysql.com/doc/refman/5.7/en/comparisons-using-subqueries.html
The most common use of a subquery is in the form: non_subquery_operand comparison_operator (subquery) Where comparison_operator is one of these operators: = > < >= <= <> != <=> For example: ... WHERE 'a' = (SELECT column1 FROM t1) MySQL also ...
https://dev.mysql.com/doc/refman/5.7/en/correlated-subqueries.html
For example: SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2 WHERE t2.column2 = t1.column2); Notice that the subquery contains a reference to a column of t1, even though the subquery's FROM clause does not mention a table t1. For ... A ...
https://dev.mysql.com/doc/refman/5.7/en/data-types.html
Consult the more detailed descriptions for additional information about particular data types, such as the permissible formats in which you can specify values. Data type descriptions use these conventions: For integer types, M indicates the maximum ... 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 ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. Dynamic format is a little more complex than static ...
https://dev.mysql.com/doc/refman/5.7/en/floating-point-types.html
MySQL uses four bytes for single-precision values and eight bytes for double-precision values. For FLOAT, the SQL standard permits an optional specification of the precision (but not the range of the exponent) in bits following the keyword FLOAT in ... The FLOAT and DOUBLE types represent approximate numeric data ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-engines-table.html
This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. SUPPORT The server's level of support for the storage engine, as shown in the following table. You might also see DISABLED for a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-virtual-table.html
CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS (5) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; However, metadata for such a column does appear in the INNODB_SYS_COLUMNS table. The ...The ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld.html
The main benefits are increased speed and more simple management for embedded applications. The API is identical for the embedded MySQL version and the client/server version. Table 27.2 MySQL Embedded Server Library Functions Function When to Call ... The embedded MySQL server library makes it possible to run a full-featured MySQL server inside a client ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-configuration-overview.html
Each of the node parameter tables lists the parameters for a given type (ndbd, ndb_mgmd, mysqld, computer, tcp, or shm). All tables include the data type for the parameter, option, or variable, as well as its default, mimimum, and maximum values as ...It is possible to update cluster configuration parameters marked as node online—that is, without shutting down the cluster—in this ...