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/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
(Observe that it could have a match, were the operator a null-safe equals <=>). Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
Examples: For conversion of a “zero” date string to a date, CONVERT() and CAST() return NULL and produce a warning when the NO_ZERO_DATE SQL mode is enabled. Table 12.15 Cast Functions and Operators Name Description BINARY Cast a string to a ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
Each of those functions, if successful, returns a binary string indicating what action occurred. Version Tokens treats token names and values as binary strings, so comparisons are case-sensitive. Otherwise, an error occurs: mysql> SELECT ... Before ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-format.html
Dynamic-format tables have these characteristics: All string columns are dynamic except those with a length less than four. Each row is preceded by a bitmap that indicates which columns contain the empty string (for string columns) or zero (for ...
https://dev.mysql.com/doc/refman/5.7/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. The value supplied must be a JSON value or a valid string representation of a JSON value. Special characters in string scalars and key ...JSON_PRETTY() prints out a JSON value in a format that is easy to ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: 2013-09-24T12:41:31.261992Z 25 [ERROR] Event Scheduler: [jon@ghidora][cookbook.e_store_ts] INSERT command ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-metrics-table.html
row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 3 MAX_COUNT: 3 MIN_COUNT: NULL AVG_COUNT: 0.046153846153846156 COUNT_RESET: 3 MAX_COUNT_RESET: 3 MIN_COUNT_RESET: NULL AVG_COUNT_RESET: NULL TIME_ENABLED: 2014-12-04 14:18:28 ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
If you want to create your own FTS_DOC_ID column, the column must be defined as BIGINT UNSIGNED NOT NULL and named FTS_DOC_ID (all uppercase), as in the following example: Note The FTS_DOC_ID column does not need to be defined as an AUTO_INCREMENT ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
Unlike the case with other partitioning types, columns used for partitioning by KEY are not restricted to integer or NULL values. This is a known issue in MySQL 5.7 which is addressed in MySQL 8.0, where this permissive behavior is deprecated, and ... Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL ...