Search Results
https://dev.mysql.com/doc/connector-python/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 ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
Returns Mysqlx.Resultset:: message Update { required Collection collection = 2; optional DataModel data_model = 3; optional Mysqlx.Expr.Expr criteria = 4; repeated Mysqlx.Datatypes.Scalar args = 8; optional Limit limit = 5; repeated Order order = 6; ... Topics in this section: Message Structure Message Sequence Common Messages Connection Session Expectations CRUD SQL Result Sets Expressions Data Types This section provides detailed information about how X Protocol defines ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-operations.html
The savePersistent() method updates an existing instance or creates a new instance as needed, without throwing an exception. For some operations—find, insert, delete, and update—it is more efficient to tell the cluster on which data node the ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-examples-requirements.html
The software requirements for running the examples found in the next few sections are as follows: A working Node.js installation Working installations of the ndb and mysql-js adapters The mysql-js adapter also requires a working installation of the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-materialized-views.html
You cannot directly update a materialized view, so INSERT, UPDATE, and DELETE statements do not work with materialized views. A materialized view is up-to-date (fresh) when all base tables that it references have not undergone any changes since the ... This topic describes how to create materialized views on MySQL HeatWave, which is supported as of MySQL ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26-u2.html
Functionality Added or Changed The following function support was added: YEARWEEK(date), YEARWEEK(date,mode) The mode argument for the two-argument form of the WEEK() function: WEEK(date[,mode]) MAKEDATE() “Zero” handling for dates such as ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-backup-details.html
Last Updated: The date and time the backup was last updated. Backup Details 18.3.1 Backup Details Use the Console to view the Backup Details page, which contains the following tabs. Table 18-1 Tabs on the Backup Details Page Name Description ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-privatelink-details.html
It continues to function with the parameters before the update was initiated. Last updated: The date and time the PrivateLink was last updated. If the PrivateLink has never been updated, it shows the date of time of its creation. PrivateLink ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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 ...