Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-ddl.html
All DDL (Data Definition Language) statements are executed using a handle structure known as a cursor. The following examples show how to create the tables of the Employee Sample Database. In a MySQL server, tables are very long-lived objects, and ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-ddl.html
All DDL (Data Definition Language) statements are executed using a handle structure known as a cursor. The following examples show how to create the tables of the Employee Sample Database. In a MySQL server, tables are very long-lived objects, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-error-messages.html
Allowed options for training are: ['task', 'model_list', 'exclude_model_list', 'optimization_metric', 'exclude_column_list', 'datetime_index', 'endogenous_variables', 'exogenous_variables', 'positive_class', 'users', 'items', 'user_columns', ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
CAST(expr AS type [ARRAY]) CAST(timestamp_value AT TIME ZONE timezone_specifier AS DATETIME[(precision)]) timezone_specifier: [INTERVAL] '+00:00' | 'UTC' With CAST(expr AS type syntax, the CAST() function takes an expression of any type and produces ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-functions.html
CREATE FUNCTION GTID_INTERSECTION_WITH_UUID(gs LONGTEXT, uuid TEXT) RETURNS LONGTEXT RETURN GTID_SUBTRACT(gs, GTID_SUBTRACT_UUID(gs, uuid)) | Example 19.1 Verifying that a replica is up to date The built-in functions GTID_SUBSET() and ... This ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-20.html
(Bug #30570249, Bug #97714) Bugs Fixed When a custom Calendar was used in the setDate method for a PreparedStatement, it was being used by subsequent calls of the same method that did not use the same calendar, resulting in the wrong date being set.
MySQL NDB Cluster API Developer Guide :: 4.2.2.5 ClusterJ Mappings Between MySQL and Java Data Types
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-mappings.html
java.util.Date represents date and time similar to the way in which Unix does so, but with more precision and a larger range. ClusterJ provides mappings for all of the common MySQL database types to Java types. Java object wrappers of primitive ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-tables.html
Given these considerations, the CREATE TABLE statement for the event table might look like this: mysql> CREATE TABLE event (name VARCHAR(20), date DATE, type VARCHAR(15), remark VARCHAR(255)); As with the pet table, it is easiest to load the initial ... The pet table keeps track of which pets you ...
https://dev.mysql.com/doc/connectors/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 ...