PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/srjs-examples.html
Next, we create a simple JavaScript stored procedure using a CREATE PROCEDURE statement that includes an OUT parameter for passing the current date and time in a human-readable format to a user variable. See the documentation for the JavaScript Date ... This section contains examples illustrating a number of different aspects of using JavaScript programs under various ...
https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html
See Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. For date and time types other than TIMESTAMP, the default is the appropriate “zero” value for the type. Otherwise, for the first TIMESTAMP column in a ...
https://dev.mysql.com/doc/refman/9.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, ...A ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-sign-keys.html
--replace-by Command-Line Format --replace-by=# Type Integer Default Value -10 Minimum Value -128 Maximum Value 127 Suggest a certificate replacement date for periodic checks, as a number of days after the CA expiration date. --schedule Command-Line ... Management of TLS keys and certificates in implemented in NDB Cluster as the executable utility program ndb_sign_keys, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-list.html
List partitioning in MySQL is similar to range partitioning in many ways. As in partitioning by RANGE, each partition must be explicitly defined. The chief difference between the two types of partitioning is that, in list partitioning, each ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/9.7/en/prepare.html
A parameter which is an operand of a temporal operator has type DATETIME if the operator returns a DATETIME, TIME if the operator returns a TIME, and DATE if the operator returns a DATE. Exceptions: The derived type is TIME and the actual type is ...
https://dev.mysql.com/doc/refman/9.7/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-replication.html
How do I know how late a replica is compared to the source? In other words, how do I know the date of the last statement replicated by the replica? A.14.4. How do I force the source to block updates until the replica catches up? A.14.5. The replica ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-configuring-consistency-guarantees.html
Read-only transactions could result in outdated values, read/write transactions could result in a rollback due to conflicts. Scenario 3: You want specific transactions to read only up-to-date data from the group, so that whenever sensitive data such ... Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: before and after transaction ...