Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-constructor.html
Syntax: cnx = MySQLConnection(**kwargs) The MySQLConnection constructor initializes the attributes and when at least one argument is passed, it tries to connect to the MySQL server. For a complete list of arguments, see Section 6.7.1, ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cursor.html
Arguments may be passed to the cursor() method to control what type of cursor to create: If buffered is True, the cursor fetches all rows from the server after an operation is executed. Syntax: cursor = cnx.cursor([arg=value[, arg=value]...]) This ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-is-connected.html
This method checks whether the connection to MySQL is available using the ping() method, but unlike ping(), is_connected() returns True when the connection is available, False otherwise.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-raise-on-warnings.html
Note You might always want to set the SQL mode if you would like to have the MySQL server directly report warnings as errors (see Section 6.9.2.52, “MySQLConnection.sql_mode Property”). This property can be assigned a value of True or False to ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-rollback.html
This method sends a ROLLBACK statement to the MySQL server, undoing all data changes from the current transaction. By default, Connector/Python does not autocommit, so it is possible to cancel transactions when using transactional storage engines ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-shutdown.html
Unlike disconnect(), shutdown() closes the client connection without attempting to send a QUIT command to the server first. Thus, it will not block if the connection is disrupted for some reason such as network failure.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-unix-socket.html
This read-only property returns the Unix socket file for connecting to the MySQL server.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-user.html
This read-only property returns the user name used for connecting to the MySQL server.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection.html
The MySQLConnection class is used to open and manage a connection to a MySQL server. It also used to send commands and SQL statements and read the results.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-fetchone.html
By default, the returned tuple consists of data returned by the MySQL server, converted to Python objects. Syntax: row = cursor.fetchone() This method retrieves the next row of a query result set and returns a single sequence, or None if no more ...