PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html
An example follows, where c1 is an AUTO_INCREMENT column of table t1: INSERT INTO t1 (c1,c2) VALUES (1,'a'), (NULL,'b'), (5,'c'), (NULL,'d'); Another type of “mixed-mode insert” is INSERT ... To make this clear, consider an example that uses ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
An extra “NULL row” provides additional information about undo log files. NDB Cluster Disk Data storage is implemented using a number of Disk Data objects. These include the following: Tablespaces act as containers for other Disk Data objects.
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
NULL, 'NULL', and Empty Values: For a column named column_name, the NULL value, an empty string, and the string value 'NULL' are distinguished from one another in the output generated by this option as follows. Value: XML Representation: NULL ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-info.html
row *************************** id: 1 select_type: SIMPLE table: trb1 partitions: p0,p1,p2,p3 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 10 Extra: Using filesort In this case, all four partitions are searched. This ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
Creating and Using ENUM Columns Index Values for Enumeration Literals Handling of Enumeration Literals Empty or NULL Enumeration Values Enumeration Sorting Enumeration Limitations Creating and Using ENUM Columns An enumeration value must be a quoted ... 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 ...
https://dev.mysql.com/doc/refman/5.7/en/gis-general-property-functions.html
ST_Dimension(g) Returns the inherent dimension of the geometry value g, or NULL if the argument is NULL. ST_Envelope(g) Returns the minimum bounding rectangle (MBR) for the geometry value g, or NULL if the argument is NULL. ST_GeometryType(g) ...
https://dev.mysql.com/doc/refman/5.7/en/gis-linestring-property-functions.html
If the argument is NULL or an empty geometry, the return value is NULL. If the argument is NULL or an empty geometry, the return value is NULL. If the argument is NULL or an empty geometry, the return value is NULL. If the argument is NULL or an ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
If the routine is a stored procedure, this value is NULL. If the routine is a stored procedure, this value is NULL. If the routine is a stored procedure, this value is NULL. If the routine is a stored procedure, this value is NULL. If the routine is ... The ROUTINES table provides information about stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/5.7/en/json-creation-functions.html
mysql> SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()); +---------------------------------------------+ | JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()) | +---------------------------------------------+ | [1, "abc", null, true, "11:30:24.000000"] | ... The functions listed in this section compose JSON values from component ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning.html
See Section 24.3.16, “The INFORMATION_SCHEMA PARTITIONS Table”, for more information; for some examples of queries against this table, see Section 22.2.7, “How MySQL Partitioning Handles NULL”. Note As of MySQL 5.7.17, the generic ...