Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-get-warnings.html
This property can be assigned a value of True or False to enable or disable whether warnings should be fetched automatically. The property can be invoked to retrieve the current warnings setting. >>> cnx.get_warnings = True >>> ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-raise-on-warnings.html
This property can be assigned a value of True or False to enable or disable whether warnings should raise exceptions. The property can be invoked to retrieve the current exceptions setting. Setting raise_on_warnings also sets get_warnings because ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-clear-attributes.html
Syntax: cursor.clear_attributes() Clear the list of query attributes on the connector's side, as set by Section 6.9.5.2, “MySQLCursor.add_attribute() Method”.
https://dev.mysql.com/doc/connectors/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 ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-executemany.html
Syntax: cursor.executemany(operation, seq_of_params) This method prepares a database operation (query or command) and executes it against all parameter sequences or mappings found in the sequence seq_of_params. Note In Python, a tuple containing a ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-get-attributes.html
Syntax: cursor.get_attributes() Return a list of existing query attributes, as set by Section 6.9.5.2, “MySQLCursor.add_attribute() Method”.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-rowcount.html
Syntax: count = cursor.rowcount This read-only property returns the number of rows returned for SELECT statements, or the number of rows affected by DML statements such as INSERT or UPDATE. For nonbuffered cursors, the row count cannot be known ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursorbuffereddict.html
A MySQLCursorBufferedDict cursor is like a MySQLCursorDict cursor, but is buffered: After executing a query, it fetches the entire result set from the server and buffers the rows. For information about the implications of buffering, see Section ...
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-net/en/connector-net-8-0-connection-options.html
CharacterSet , Character Set , CharSet Specifies the character set that should be used to encode all queries sent to the server. This chapter describes the full set of MySQL Connector/NET 8.0 connection options. The protocol you use to make a ...