Search Results
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
mysql_tzinfo_to_sql This program loads the time zone tables in the mysql database using the contents of the host system zoneinfo database (the set of files describing time zones). MySQL client programs that connect to the MySQL server: mysql The ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
If one of the arguments is a TIMESTAMP or DATETIME column and the other argument is a constant, the constant is converted to a timestamp before the comparison is performed. To be safe, always use complete datetime, date, or time strings when doing ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
One of the key features of MySQL ', 'is its support for stored procedures, which allow developers to create reusable blocks of ', 'code that can be executed multiple times. This method is faster than running the ML_GENERATE routine multiple times.
https://dev.mysql.com/doc/internals/en/logging-transactions-preliminary-rules.html
(PR-causality) If statement A is executed before statement B, and B is logged in statement format, and B reads tables that A may modifies, then B shall be logged after A. In particular, changes to N-tables shall be written to the binary log when ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-data-placement.html
Partitioning table data by JOIN and GROUP BY key columns can improve query performance by avoiding costs associated with redistributing data among MySQL HeatWave nodes at query execution time. A query executed on a table that is no longer loaded or ...Data placement keys are used to partition table data among MySQL HeatWave nodes when loading ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
The Performance Schema has these characteristics: The Performance Schema provides a way to inspect internal execution of the server at runtime. The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. An ...It ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-reconnect.html
The argument attempts specifies the number of times a reconnect is tried. The delay argument is the number of seconds to wait between each retry. Syntax: cnx.reconnect(attempts=1, delay=0) Attempt to reconnect to the MySQL server. You might set the ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-reconnect.html
The argument attempts specifies the number of times a reconnect is tried. The delay argument is the number of seconds to wait between each retry. Syntax: cnx.reconnect(attempts=1, delay=0) Attempt to reconnect to the MySQL server. You might set the ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-operator-functions.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-overview.html
This might include: prepare the SQL statement and execute the SQL statement, or execute it directly without prepare. Interacting with a MySQL server from an applications using the Connector/ODBC typically involves the following operations: ...