Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/c-api/8.4/en/c-api-prepared-statement-data-structures.html
For date and time data types, buffer should point to a MYSQL_TIME structure. MYSQL_TIME This structure is used to send and receive DATE, TIME, DATETIME, and TIMESTAMP data directly to and from the server. Set the buffer member to point to a ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-13.html
(Bug #28444461) Connector/J now translates the legacy value of convertToNull for the connection property zeroDateTimeBehavior to CONVERT_TO_NULL. (Bug #28034570, Bug #90887) Setting rewriteBatchedStatements=true and useLocalTransactionState=true ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-8.html
(WL #10532) Conversion from the MySQL TIME data to java.sql.Date is now supported. In the past, a getDate() retrieving data from a TIME column would throw an SQLException. (Bug #26646676) Updated the timezone mappings using the latest IANA and CLDR ... Version 8.0.8 Development Milestone is the latest development release of the 8.0 branch of MySQL Connector/J, providing an insight into upcoming ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
DATE DATE DATETIME DATETIME DATETIME2 DATETIME Date range in MySQL is '1000-01-01 00:00:00.000000' to '9999-12-31 23:59:59.999999'. SMALLDATETIME DATETIME DATETIMEOFFSET DATETIME TIME TIME TIMESTAMP TIMESTAMP ROWVERSION TIMESTAMP BINARY ... The ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
How can I view my MySQL Workbench query history? In bottom pane, change Action Output to History and then choose the appropriate date. These files are organized per date (such as 2014-01-15) and contain your MySQL Workbench SQL statement history for ... FAQ Categories Basic Usage MySQL Workbench Functionality Data Management General Basic Usage ...