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/fractional-seconds.html
MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...For ...A value of 0 signifies that there is no fractional ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
delayed_insert_timeout Command-Line Format --delayed-insert-timeout=# Deprecated Yes System Variable delayed_insert_timeout Scope Global Dynamic Yes Type Integer Default Value 300 Minimum Value 1 Maximum Value 31536000 Unit seconds This system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
innodb_flush_log_at_timeout Command-Line Format --innodb-flush-log-at-timeout=# System Variable innodb_flush_log_at_timeout Scope Global Dynamic Yes Type Integer Default Value 1 Minimum Value 1 Maximum Value 2700 Unit seconds Write and flush the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-fractional-seconds.html
MySQL 5.7 permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision. There may be problems replicating from a source server that understands fractional seconds to an older replica (MySQL 5.6.3 ...Statements that use temporal data types with an fsp value of 0 work with statement-based logging but not row-based ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-import.html
These files are kept on successful completion even if --keep-state is not used ADDED: NDB 7.6.4 --tempdelay=# Number of milliseconds to sleep between temporary errors ADDED: NDB 7.6.2 --temperrors=# Number of times a transaction can fail due to a ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second support. Time Zone Variables Populating the ...For information about time zone settings in replication setups, see Section 16.4.1.15, “Replication and System Functions” and Section 16.4.1.31, “Replication and Time ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
When unix_timestamp is a decimal value, the fractional seconds precision of the DATETIME is the same as the precision of the decimal value, up to a maximum of 6. Functions that return the current date or time each are evaluated only once per query ...See Section 11.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be ...
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-row.html
Task: Find the number, dealer, and price of the most expensive article.
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-column-group-row.html
Task: For each article, find the dealer or dealers with the most expensive price. Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause or a LEFT JOIN.
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-column-group.html
SELECT article, MAX(price) AS price FROM shop GROUP BY article ORDER BY article; +---------+-------+ | article | price | +---------+-------+ | 0001 | 3.99 | | 0002 | 10.99 | | 0003 | 1.69 | | 0004 | 19.95 | +---------+-------+ .