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/performance-schema-events-statements-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. If an event is produced from an instrument that has TIMED = NO, timing information is not collected, and TIMER_START, ...The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
mysql> CREATE TABLE t2 (c1 VARCHAR(65533) NOT NULL) ENGINE = InnoDB CHARACTER SET latin1; Query OK, 0 rows affected (0.01 sec) For MyISAM tables, NULL columns require additional space in the row to record whether their values are NULL. Each NULL ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes.html
row *************************** id: 1 select_type: SIMPLE table: jemp partitions: NULL type: range possible_keys: i key: i key_len: 5 ref: NULL rows: 2 filtered: 100.00 Extra: Using where 1 row in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G ...
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/innodb-memcached-porting-mysql.html
Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-general-purpose.html
If the key cannot be created, the return value is NULL and an error occurs. mysql> SELECT @x; +------+ | @x | +------+ | NULL | +------+ mysql> SELECT keyring_key_generate('x', 'AES', 16) INTO @x; mysql> SELECT @x; +------+ | @x | +------+ | 1 | ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
When the primary key is extended with an additional column or columns, any columns added must be defined as NOT NULL, and no values in any such columns may be changed during the time that the backup is being taken. Beginning with NDB 7.6.19, ... New ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-quick-start.html
row *************************** Table: setup_consumers Create Table: CREATE TABLE `setup_consumers` ( `NAME` varchar(64) NOT NULL, `ENABLED` enum('YES','NO') NOT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 Table structure is also available ... This section briefly introduces the Performance Schema with examples that show how to use ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
AND key_partN cmp constN; Here, const1, const2, … are constants, cmp is one of the =, <=>, or IS NULL comparison operators, and the conditions cover all index parts. For a BTREE index, an interval might be usable for conditions combined with AND, ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...