PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
For example: mysql> SELECT DAYOFMONTH('2001-11-00'), MONTH('2005-00-00'); -> 0, 0 Other functions expect complete dates and return NULL for incomplete dates. For example: mysql> SELECT DATE_ADD('2006-05-00',INTERVAL 1 DAY); -> NULL mysql> SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-example.html
* * You can use mysql_library_init(0, NULL, NULL), and it * initializes the server using groups = { * "server", "embedded", NULL * }. These two example programs should work without any changes on a Linux or FreeBSD system. For other operating ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
row *************************** THREAD_ID: 1 NAME: thread/sql/main TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 80284 PROCESSLIST_STATE: NULL ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-table-info.html
For strings, it may be shorter than the full length of the indexed column, because you can index a prefix of a string column. Nullpos, Nullbit For columns that can be NULL, MyISAM stores NULL values as a flag in a byte. Depending on how many ... To ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
CHARACTER_MAXIMUM_LENGTH For stored function string return values, the maximum length in characters. If the routine is a stored procedure, this value is NULL. CHARACTER_OCTET_LENGTH For stored function string return values, the maximum length in ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
MySQL 5.7 supports explicit selection of partitions and subpartitions that, when executing a statement, should be checked for rows matching a given WHERE condition. Partition selection is similar to partition pruning, in that only specific ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
Given this statement: CREATE TABLE t AS SELECT INET6_NTOA(expr) AS c1; The resulting table would have this definition: CREATE TABLE t (c1 VARCHAR(39) CHARACTER SET utf8 DEFAULT NULL); The return string uses lowercase letters for IPv6 addresses. The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-fulltext_index-tables.html
When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are removed from the INNODB_FT_DELETED table. INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE ...
https://dev.mysql.com/doc/refman/5.7/en/json-attribute-functions.html
Returns NULL if any argument is NULL or the path argument does not identify a value in the document. The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty ...