Search Results
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
The MySQL server writes some error messages to its error log, and sends others to client programs. Example server-side error messages written to the error log: 2018-10-28T13:01:32.735983Z 0 [Note] [MY-010303] [Server] Skipping generation of SSL ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-23.html
Version 8.0.23 is the latest General Availability release of the 8.0 series of MySQL Connector/J. It is suitable for use with MySQL Server versions 8.0 and 5.7. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI.
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-extension-createresult-data-specification.html
The data definition of a result is composed of the following elements: Column metadata: the column names and their types. Automatically Defined Column Data The first dictionary defined in data is used to automatically determine the column metadata.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-time-zone.html
This property is used to set or retrieve the time zone session variable for the current connection. >>> cnx.time_zone = '+00:00' >>> cursor = cnx.cursor() >>> cursor.execute('SELECT NOW()') ; cursor.fetchone() (datetime.datetime(2012, 6, 15, 11, ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-select.html
The following example shows how to query data using a cursor created using the connection's cursor() method. The task is to select all employees hired in the year 1999 and print their names and hire dates to the console. We then create a new ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-transaction.html
Inserting or updating data is also done using the handler structure known as a cursor. 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, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-time-zone.html
This property is used to set or retrieve the time zone session variable for the current connection. >>> cnx.time_zone = '+00:00' >>> cursor = cnx.cursor() >>> cursor.execute('SELECT NOW()') ; cursor.fetchone() (datetime.datetime(2012, 6, 15, 11, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-select.html
The following example shows how to query data using a cursor created using the connection's cursor() method. The task is to select all employees hired in the year 1999 and print their names and hire dates to the console. We then create a new ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
Inserting or updating data is also done using the handler structure known as a cursor. 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, ...