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/information-schema-innodb-trx-table.html
TRX_REQUESTED_LOCK_ID The ID of the lock the transaction is currently waiting for, if TRX_STATE is LOCK WAIT; otherwise NULL. TRX_WAIT_STARTED The time when the transaction started waiting on the lock, if TRX_STATE is LOCK WAIT; otherwise NULL. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
In some cases (for example, the ROUTINE_DEFINITION column in the INFORMATION_SCHEMA ROUTINES table), users who have insufficient privileges see NULL. If this field is NULL, it means that the value of the column is always NULL. INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers created in MySQL 5.7.2 or later, NULL for triggers created prior to 5.7.2. To see information about a table's triggers, you must have the TRIGGER privilege ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-ddl.html
You can access the underlying InnoDB table (which is test.demo_test by default) through standard SQL interfaces. However, there are some restrictions: When querying a table that is also accessed through the memcached interface, remember that ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
When you insert a value of NULL into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. (AUTO_INCREMENT sequences begin with 1.) Storing 0 into an AUTO_INCREMENT column has the same effect as storing NULL, unless the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
The rows that do not contain NULL indicate which timers you can use in setup_timers. The timers in setup_timers that you can use are those that do not have NULL in the other columns. If the values associated with a given timer name are NULL, that ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-options-system-variables.html
mysqlx_ssl_ca Command-Line Format --mysqlx-ssl-ca=file_name Introduced 5.7.12 System Variable mysqlx_ssl_ca Scope Global Dynamic No Type File name Default Value NULL The mysqlx_ssl_ca system variable is like ssl_ca, except that it applies to X ...
https://dev.mysql.com/doc/refman/5.7/en/all-subqueries.html
The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The expression is unknown (that is, NULL) if table t2 contains (0,NULL,1). The expression is TRUE if table t2 ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'] AS (expr) indicates that the column is generated and defines the ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. Table-level options for controlling read from any replica and partition balance can be ...