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-information-schema-metrics-table.html
Because no DML operations have been performed, the counter values are zero or NULL. row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 0 MAX_COUNT: 0 MIN_COUNT: NULL AVG_COUNT: 0 COUNT_RESET: 0 MAX_COUNT_RESET: 0 ... The ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
If this mode is not enabled, division by zero inserts NULL and produces no warning. If this mode is enabled, division by zero inserts NULL and produces a warning. For INSERT IGNORE and UPDATE IGNORE, division by zero inserts NULL and produces a ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html
These rows have the country and products columns set to NULL. This row has the year, country, and products columns set to NULL. The NULL indicators in each super-aggregate row are produced when the row is sent to the client. For any column in the ...
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/encryption-functions.html
If AES_DECRYPT() detects invalid data or incorrect padding, it returns NULL. However, it is possible for AES_DECRYPT() to return a non-NULL value (possibly garbage) if the input data or the key is invalid. Note If you are using a KDF, you must ...If ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
SET NULL: Delete or update the row from the parent table and set the foreign key column or columns in the child table to NULL. Both ON DELETE SET NULL and ON UPDATE SET NULL clauses are supported. If you specify a SET NULL action, make sure that you ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/5.7/en/gis-polygon-property-functions.html
If the argument is NULL or an empty geometry, the return value is NULL. If the argument is an empty geometry collection, 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 ... Functions in this section return properties of Polygon or MultiPolygon ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. Typically the first audit record written after plugin startup contains the server description and startup options. Elements ...
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/ansi-diff-foreign-keys.html
If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it has previously updated during the same cascade, it acts like RESTRICT. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE SET NULL operations. A self-referential ON DELETE SET NULL, on the other hand, is possible, as is a self-referential ON DELETE ...For example, if you define a RESTRICT type constraint, ...