Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-warning.html
This exception is used for reporting important warnings, however, Connector/Python does not use it. It is included to be compliant with the Python Database Specification v2.0 (PEP-249). Consider using either more strict Server SQL Modes or the ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-autocommit.html
This property can be assigned a value of True or False to enable or disable the autocommit feature of MySQL. The property can be invoked to retrieve the current autocommit setting. When the autocommit is turned off, you must commit transactions ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-change-user.html
It also causes the specified database to become the default (current) database. It is also possible to change the character set using the charset argument. Syntax: cnx.cmd_change_user(username='', password='', database='', charset=33) Returns a ...
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-process-kill.html
Although still available, it is better to use the KILL SQL statement. The following two lines have the same effect: >>> cnx.cmd_process_kill(123) >>> cnx.cmd_query('KILL 123') .
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-disconnect.html
This method tries to send a QUIT command and close the socket. To shut down the connection without sending a QUIT command first, use shutdown().
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-get-rows.html
Syntax: cnx.get_rows(count=None) This method retrieves all or remaining rows of a query result set, returning a tuple containing the rows as sequences and the EOF packet information. The count argument can be used to obtain a given number of rows.
https://dev.mysql.com/doc/connectors/en/connector-python-examples.html
These coding examples illustrate how to develop Python applications and scripts which connect to MySQL Server using MySQL Connector/Python.
https://dev.mysql.com/doc/connectors/en/connector-python-tutorials.html
These tutorials illustrate how to develop Python applications and scripts that connect to a MySQL database server using MySQL Connector/Python.