Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
Pruning can also be applied for tables partitioned on a DATE or DATETIME column when the partitioning expression uses the YEAR() or TO_DAYS() function. Important Invalid DATE and DATETIME values referenced in the WHERE condition of a statement ...
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. PREPARE stmt_name FROM preparable_stmt The PREPARE statement ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.point.html
You can restore your database server to its state at an arbitrary time using the binary log files included in the backups. The process assumes that following conditions are met: The backed-up MySQL Server has had its binary logging enabled (which ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-date-handling.html
The binary (prepared statement) protocol enables you to send and receive date and time values (DATE, TIME, DATETIME, and TIMESTAMP), using the MYSQL_TIME structure. For DATE, TIME, DATETIME, or TIMESTAMP values, set buffer_type to MYSQL_TYPE_DATE, ...The members of this structure are described in Section 6.2, “C API Prepared Statement Data ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-type-codes.html
The buffer_type member of MYSQL_BIND structures indicates the data type of the C language variable bound to a statement parameter or result set column. For input, buffer_type indicates the type of the variable containing the value to be sent to the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-data-split.html
The following data types for this column are supported: DATETIME TIMESTAMP DATE TIME YEAR semisupervised: If running an anomaly detection task, set this to true for semi-supervised learning, or false for unsupervised learning. You can automatically ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-train-test-split.html
Order the table by the datetime_index values and select the first 80% of the samples for the training dataset. TRAIN_TEST_SPLIT Syntax mysql> CALL sys.TRAIN_TEST_SPLIT ('table_name', 'target_column_name', [options | NULL]); options: { ... The ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
DATE DATE TIME TIME TIMESTAMP DATETIME INTERVAL TIME BYTEA LONGBLOB TEXT LONGTEXT CIDR VARCHAR(43) INET VARCHAR(43) MACADDR VARCHAR(17) UUID VARCHAR(36) XML LONGTEXT JSON LONGTEXT TSVECTOR LONGTEXT TSQUERY LONGTEXT ARRAY LONGTEXT POINT POINT LINE ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-configuration-properties.html
Configuration properties define how Connector/J will make a connection to a MySQL server. Unless otherwise noted, properties can be set for a DataSource object or for a Connection object. If you specify a configuration property in the URL without ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-reference-datatypes.html
The following table illustrates how Connector/ODBC maps the server data types to default SQL and C data types.