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/replication-delayed.html
MySQL 5.7 supports delayed replication such that a replica server deliberately lags behind the source by at least a specified amount of time. Use the MASTER_DELAY option for CHANGE MASTER TO to set the delay to N seconds: CHANGE MASTER TO ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/5.7/en/rewriting-subqueries.html
Sometimes there are other ways to test membership in a set of values than by using a subquery. Also, on some occasions, it is not only possible to rewrite a query without a subquery, but it can be more efficient to make use of some of these ...
https://dev.mysql.com/doc/refman/5.7/en/row-subqueries.html
The expression is unknown (that is, NULL) if the subquery produces no rows. Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that returns a single row and can thus return more than one ...
https://dev.mysql.com/doc/refman/5.7/en/se-csv-limitations.html
All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns. Partitioning is not supported for tables using the CSV storage engine.
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
All partition-specific columns in the Information Schema PARTITIONS table display NULL. When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program Options”. The ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html
If you do not have privileges for the routine itself, the value displayed for the Create Procedure or Create Function column is NULL. SHOW CREATE PROCEDURE proc_name This statement is a MySQL extension. It returns the exact string that can be used ...
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.