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/show-create-trigger.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. SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER ...
https://dev.mysql.com/doc/refman/5.7/en/show-engines.html
row *************************** Engine: BLACKHOLE Support: YES Comment: /dev/null storage engine (anything you write to it disappears) Transactions: NO XA: NO Savepoints: NO *************************** 5. SHOW [STORAGE] ENGINES SHOW ENGINES ...
https://dev.mysql.com/doc/refman/5.7/en/show-profile.html
For values that depend on the getrusage() system call, NULL is returned on systems such as Windows that do not support the call. Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release.
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.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. SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
It is illegal to assign NULL to a condition information item in a SIGNAL statement. SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics ...
https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html
Columns that are part of a PRIMARY KEY are made NOT NULL even if not declared that way. In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-materialization.html
oe [NOT] IN (SELECT ie ...) The predicate is IN or NOT IN and a result of UNKNOWN (NULL) has the same meaning as a result of FALSE. The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-file-io-type.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. These views summarize file I/O, grouped by host and event type. By default, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-file-io.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. By default, rows are sorted by descending total file I/O latency. The ...