Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
This is similar to how MySQL treats other temporal types such as DATETIME. For additional information, see Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. BACKUP If the data file was changed during recovery, ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.4/en/using-date.html
MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP column. When you compare a DATE, TIME, DATETIME, or TIMESTAMP to a constant string with the <, <=, =, >=, >, ...You should use this format in UPDATE expressions and in the WHERE clause of SELECT ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-data-structures.html
MYSQL_TIME This structure is used to send and receive DATE, TIME, DATETIME, and TIMESTAMP data directly to and from the server. Set the buffer member to point to a MYSQL_TIME structure, and set the buffer_type member of a MYSQL_BIND structure to one ... Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer to a MYSQL_STMT data ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-2-0.html
(Bug #35358417) Using javax.sql.rowset.CachedRowSet#getDate() or javax.sql.rowset.CachedRowSet#getTimestamp() on DATETIME fields resulted in a ClassCastException. It was because the default return type of DATETIME fields by ResultSet.getObject() was ... Version 8.2.0 is a new GA release of MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-execute.html
In the preceding example, the datetime.date() instance is converted to '2012-03-23'. Syntax: cursor.execute(operation, params=None) iterator = cursor.execute(operation, params=None) # Allowed before 9.2.0 iterator = cursor.execute(operation, ...
https://dev.mysql.com/doc/connectors/en/connector-python-introduction.html
Converting parameter values back and forth between Python and MySQL data types, for example Python datetime and MySQL DATETIME. MySQL Connector/Python enables Python programs to access MySQL databases, using an API that is compliant with the Python ...
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 ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-execute.html
In the preceding example, the datetime.date() instance is converted to '2012-03-23'. Syntax: cursor.execute(operation, params=None) iterator = cursor.execute(operation, params=None) # Allowed before 9.2.0 iterator = cursor.execute(operation, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-introduction.html
Converting parameter values back and forth between Python and MySQL data types, for example Python datetime and MySQL DATETIME. MySQL Connector/Python enables Python programs to access MySQL databases, using an API that is compliant with the Python ...
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 ...