Search Results
https://dev.mysql.com/doc/refman/8.4/en/replace.html
For another MySQL extension to standard SQL—that either inserts or updates—see Section 15.2.7.2, “INSERT ... If you are using the C API, the affected-rows count can be obtained using the mysql_affected_rows() function. MySQL uses the following ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
(For more information, see Section 12.8.5, “The binary Collation Compared to _bin Collations”.) Note Within the mysql client, binary strings display using hexadecimal notation, depending on the value of the --binary-as-hex. For more information ... A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") ...
https://dev.mysql.com/doc/refman/8.4/en/tutorial.html
mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the results. This chapter provides a tutorial introduction to MySQL by ...If you are interested only in accessing an existing database, you may want to skip the sections that describe how to create the database and the tables it ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-parallel-load-overview.html
Lakehouse Auto Parallel Load, which extends the Auto Parallel Load feature of MySQL HeatWave, facilitates the process of loading data from Object Storage into MySQL HeatWave by automating many of the steps involved, including: Excluding schemas, ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
NETWORK_NAMESPACE = 'namespace' The network namespace to use for TCP/IP connections to the replication source server or, if the MySQL communication stack is in use, for Group Replication’s group communication connections. A divergence based on the ...] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
For example: mysql> SELECT CONVERT_TZ(O_ORDERDATE, 'UTC','EST') FROM tpch.orders; Rewrite as: mysql> SELECT CONVERT_TZ(O_ORDERDATE, '+00:00','-05:00') FROM tpch.orders; Only UNIX_TIMESTAMP() and FROM_UNIXTIME() functions support a timezone value ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
DATE DATE DATETIME DATETIME DATETIME2 DATETIME Date range in MySQL is '1000-01-01 00:00:00.000000' to '9999-12-31 23:59:59.999999'. The following table shows the mapping between Microsoft SQL Server (source) data types and MySQL data types. Table ...SMALLINT SMALLINT BIGINT BIGINT BIT TINYINT(1) FLOAT FLOAT Precision value is used for storage size in ...
https://dev.mysql.com/doc/connectors/en/connector-python-django-backend.html
Django's DateTimeField is stored in a MySQL column defined as DATETIME(6), and TimeField is stored as TIME(6). Connector/Python includes a mysql.connector.django module that provides a Django back end for MySQL. This back end supports new features ...Django Configuration Django uses a configuration file named settings.py that contains a variable called DATABASES (see ...
https://dev.mysql.com/doc/connector-python/en/connector-python-django-backend.html
Django's DateTimeField is stored in a MySQL column defined as DATETIME(6), and TimeField is stored as TIME(6). Connector/Python includes a mysql.connector.django module that provides a Django back end for MySQL. This back end supports new features ...Django Configuration Django uses a configuration file named settings.py that contains a variable called DATABASES (see ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-report-table.html
All versions prior to MySQL 8.0.32 use the heatwave_advisor_report and heatwave_load_report tables for reporting Autopilot Advisor and load activities. It contains data from the last execution of Advisor or Auto Parallel Load. Data is only available ...