Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-errorcodes.html
The following tables lists the error codes returned by Connector/ODBC apart from the server errors.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-column-names.html
Syntax: sequence = cursor.column_names This read-only property returns the column names of a result set as sequence of Unicode strings.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-execute.html
Syntax: cursor.execute(operation, params=None) iterator = cursor.execute(operation, params=None) # Allowed before 9.2.0 iterator = cursor.execute(operation, params=None, multi=True) This method executes the given database operation (query or ...The ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-31.html
(Bug #33987119) Changed the warning_count property from private to public in the cursor class; this is used to retrieve the number of warnings generated by the previously executed operation. (Bug #27634910) When using buffered cursors with the C ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-32.html
(Bug #34556157) When using a prepared cursor, a DATETIME column containing 00:00:00 as the time value caused a Python date object was returned instead of a datetime. (Bug #108733, Bug #34689812) The MySQLCursor.executemany() method failed to batch ... Functionality Added or Changed Bugs Fixed Functionality Added or Changed Removed distutils support, which is deprecated in Python 3.10 and removed in Python ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Backspace deletes the character before the cursor and typing new characters enters them at the cursor position. For example, in libedit, Control+W deletes everything before the current cursor position and Control+U deletes the entire line. In ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-toolbar.html
Execute the statement under the keyboard cursor: Uses the position the keyboard cursor to identify and execute the query. Execute the EXPLAIN command on the statement under the keyboard cursor: Uses the position the keyboard cursor to identify the ... The SQL query toolbar provides actions that enable you to create and manage ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-get-warnings.html
>>> cnx.get_warnings = True >>> cursor.execute('SELECT "a"+1') >>> cursor.fetchall() [(1.0,)] >>> cursor.fetchwarnings() [(u'Warning', 1292, u"Truncated incorrect DOUBLE value: 'a'")] Returns True or False. This property can be assigned a value of ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-close.html
Syntax: cursor.close() Use close() when you are done using a cursor. This method closes the cursor, resets all results, and ensures that the cursor object has no reference to its original connection object.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-description.html
Syntax: tuples = cursor.description This read-only property returns a list of tuples describing the columns in a result set. Each tuple in the list contains values as follows: (column_name, type, None, None, None, None, null_ok, column_flags) The ...