Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-debug.html
Instructs the server to write debugging information to the error log.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-ping.html
Checks whether the connection to the server is working. This method is not to be used directly. Use ping() or is_connected() instead. Returns a dictionary containing the OK packet information. ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-quit.html
This method sends a QUIT command to the MySQL server, closing the current connection. Since there is no response from the MySQL server, the packet that was sent is returned.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-refresh.html
Example: >>> from mysql.connector import RefreshOption >>> refresh = RefreshOption.LOG | RefreshOption.THREADS >>> cnx.cmd_refresh(refresh) . This method flushes tables or caches, or resets replication server information. The options argument should ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-shutdown.html
Deprecation This MySQL Server functionality is deprecated. Asks the database server to shut down. The connected user must have the SHUTDOWN privilege. Returns a dictionary containing the OK packet information. ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-converter-class.html
This property sets and returns the converter class to use when configuring the connection. # get the current converter class being used print(cnx.converter_class) >> <class 'mysql.connector.conversion.MySQLConverter'> class ...# set the custom ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-disconnect.html
To shut down the connection without sending a QUIT command first, use shutdown(). This method tries to send a QUIT command and close the socket.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-get-server-info.html
This method returns the MySQL server information verbatim as a string, for example '5.6.11-log', or None when not connected.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-get-server-version.html
This method returns the MySQL server version as a tuple, or None when not connected.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-in-transaction.html
This property returns True or False to indicate whether a transaction is active for the connection. >>> cnx.start_transaction() >>> cnx.in_transaction True >>> cnx.commit() >>> cnx.in_transaction False in_transaction was added in MySQL ...The value ...