Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-known-issues-limitations.html
In order to avoid such errors, we recommend setting a connection time zone that uses a monotonic clock by, for example, setting connectionTimeZone=UTC, and configuring other date-time connection properties according to your needs; see Section 3.5.6, ... The following are some known issues and limitations for MySQL Connector/J: When Connector/J retrieves timestamps for a daylight saving time (DST) switch day using the getTimeStamp() method on the result set, some of the returned values might be ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-a-forecasting-model.html
mysql> CREATE TABLE electricity_demand ( date DATE PRIMARY KEY, demand FLOAT NOT NULL, temperature FLOAT NOT NULL ); Insert the sample data into the table. mysql> CREATE TABLE electricity_demand_train AS SELECT * FROM electricity_demand WHERE date < ... This topic describes how to prepare the data to use for a forecasting machine learning ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-known-issues-limitations.html
In order to avoid such errors, we recommend setting a connection time zone that uses a monotonic clock by, for example, setting connectionTimeZone=UTC, and configuring other date-time connection properties according to your needs; see Section 6.6, ... The following are some known issues and limitations for MySQL Connector/J: When Connector/J retrieves timestamps for a daylight saving time (DST) switch day using the getTimeStamp() method on the result set, some of the returned values might be ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
This is an example of a minimal CREATE EVENT statement: CREATE EVENT myevent ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO UPDATE myschema.mytable SET mycol = mycol + 1; The previous statement creates an event named myevent. It specifies ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
Restore backup of s2 onto the host for s3: s3> mysqlbackup --defaults-file=/etc/my.cnf \ --datadir=/var/lib/mysql \ --backup-image=/backups/my.mbi_2206_1429 \ --backup-dir=/tmp/restore_`date +%d%m_%H%M` copy-back-and-apply-log Note The command above ... MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
EXECUTE_AT For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to create the event, or of the last ALTER EVENT statement that modified the event. This is displayed as a DATETIME value, and ... The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
Partial Updates of JSON Values In MySQL 8.4, the optimizer can perform a partial, in-place update of a JSON column instead of removing the old document and writing the new document in its entirety to the column. This optimization can be performed ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-row-events.html
These correspond to events with the WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT type codes. # at 302 #080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F BINLOG ' ... The following examples ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
RANGE COLUMNS partitioning columns are not restricted to integer columns; string, DATE and DATETIME columns can also be used as partitioning columns. Range columns partitioning is similar to range partitioning, but enables you to define partitions ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-transaction.html
When you use a transactional storage engine such as InnoDB (the default in MySQL 5.5 and higher), you must commit the data after a sequence of INSERT, DELETE, and UPDATE statements. We could calculate tomorrow by calling a database function, but for ... Inserting or updating data is also done using the handler structure known as a ...