PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
To permit a TIMESTAMP column to contain NULL, explicitly declare it with the NULL attribute. (For a TIMESTAMP column not declared with the NULL attribute, DEFAULT NULL is invalid.) If a TIMESTAMP column permits NULL values, assigning NULL sets it to ... TIMESTAMP and DATETIME columns can be automatically initialized and updated to the current date and time (that is, the current ...
https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html
Variables using the syntax $variable_name can be declared and used with these functions when they are called inside stored programs. Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
If the expression evaluates to a data type that differs from the declared column type, implicit coercion to the declared type occurs according to the usual MySQL type-conversion rules. In MySQL 8.0.22 and later, if the column is also declared as NOT ...Values of a generated column are computed from an expression included in the column ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
Note If you declare an alias for a table, you must use the alias when referring to the table: DELETE t1 FROM test AS t1, test2 WHERE ... Table aliases in a multiple-table DELETE should be declared only in the table_references part of the statement.
https://dev.mysql.com/doc/refman/8.0/en/lock-order-tool.html
If lock_order is enabled, an error is raised if the server encounters a lock-acquisition sequence that is not declared in the lock-order graph. lock_order_debug_missing_arc Command-Line Format --lock-order-debug-missing-arc[={OFF|ON}] System ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data-objects.html
You cannot add an index to a column that has been explicitly declared STORAGE DISK, without first changing its storage type to MEMORY; any attempt to do so fails with an error. By “implicitly”, we mean a column whose storage type is not ... NDB ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
For example, for a column declared as INT(4) ZEROFILL, a value of 5 is retrieved as 0005. Inserting NULL to generate AUTO_INCREMENT values requires that the column be declared NOT NULL. If the column is declared NULL, inserting NULL stores a NULL.
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 14.24.3, “Expression Handling”, and Section 14.24.4, “Rounding Behavior”. Consider the ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
String Type Storage Requirements In the following table, M represents the declared column length in characters for nonbinary string types and bytes for binary string types. If the same column is instead declared to use the ucs2 double-byte character ... InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage requirements for table data on disk depend on several ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
For the ENUM and SET data types, this does not occur; they are created as declared. For the CHAR, VARCHAR, TEXT, ENUM, and SET data types, you can declare a column with a binary (_bin) collation or the BINARY attribute to cause comparison and ...