Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-tutorial-cursorbuffered.html
The following example script gives a long-overdue 15% raise effective tomorrow to all employees who joined in the year 2000 and are still with the company. (A buffered cursor fetches and buffers the rows of a result set after executing a query; see ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-mysql-configuration-details.html
Last updated The date and time the configuration was last updated. If the configuration has never been updated, it shows the date of time of its creation. Last updated: The date and time the configuration was last updated. If the configuration has ... MySQL Configuration Details 19.3 MySQL Configuration Details Follow these steps to view details of your MySQL configurations: In the MySQL HeatWave Console, select the Resources tab, and then click the Configurations ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
Any type coercion mandated by an expression that makes use of the return value is now performed following function execution. Examples: If you compare a DATETIME to two DATE values, convert the DATE values to DATETIME values. If you use a string ...
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/connectors/en/connector-j-time-instants.html
Starting from MySQL 8.0.19, you can also specify a time zone offset when storing TIMESTAMP values (see The DATE, DATETIME, and TIMESTAMP Types for details), in which case the TIMESTAMP values are converted to the UTC from the specified offset ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
-- Attributes -- c1 Datetime NULL AT=FIXED ST=MEMORY c2 Date NULL AT=FIXED ST=MEMORY c3 Time NULL AT=FIXED ST=MEMORY c4 Timestamp NOT NULL AT=FIXED ST=MEMORY DEFAULT 0 c5 Year NULL AT=FIXED ST=MEMORY The affected MySQL types are TIME, DATETIME, and ... This section provides information about the way in which MySQL data types are represented in NDBCLUSTER table columns and how these values can be accessed in NDB API ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-generated-columns.html
For example: CREATE EXTERNAL TABLE customer ( date_col DATE, month_col INT GENERATED ALWAYS AS (MONTH(`date_col`)) STORED ); A function over a constant value. For example: CREATE EXTERNAL TABLE customer ( date_col DATE, month_col INT GENERATED ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
You can set the date_format, time_format, timestamp_format, datetime_format (as of MySQL 9.5.1), and model as optional column-level ENGINE_ATTRIBUTE parameters. If you set both timestamp_format and datetime_format, only the datetime_format is used ... External tables use table-level and column-level ENGINE_ATTRIBUTE options of the CREATE TABLE statement to specify the parameters needed to process data stored externally in Object ...
https://dev.mysql.com/doc/connector-j/en/connector-j-time-instants.html
Starting from MySQL 8.0.19, you can also specify a time zone offset when storing TIMESTAMP values (see The DATE, DATETIME, and TIMESTAMP Types for details), in which case the TIMESTAMP values are converted to the UTC from the specified offset ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
For example, strict SQL mode can be enabled, or the mode can include values such as NO_ZERO_DATE or NO_ZERO_IN_DATE. An invalid value for a DATETIME, DATE, or TIME column is inserted as the implicit default value, regardless of the SQL mode ...The ...