Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-connected.html
Syntax: is_connected = ccnx.connected() Returns True or False to indicate whether the MySQL instance is connected.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-fetch-row.html
Syntax: row = ccnx.fetch_row() Fetches the next row from the active result set. The row is returned as a tuple that contains the values converted to Python objects, unless raw was set. ccnx.query('SELECT CURRENT_USER(), 1 + 3, NOW()') row = ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-more-results.html
Syntax: more = ccnx.more_results() Returns True or False to indicate whether any more result sets exist.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-query.html
ccnx.query('DROP TABLE IF EXISTS t') ccnx.query('CREATE TABLE t (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY)') ccnx.query('INSERT INTO t (i) VALUES (NULL),(NULL),(NULL)') ccnx.query('SELECT LAST_INSERT_ID()') row = ccnx.fetch_row() ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-use-unicode.html
Syntax: is_unicode = ccnx.use_unicode() # getter ccnx.use_unicode(bool) # setter With no argument, returns True or False to indicate whether the MySQL instance returns nonbinary strings as Unicode. With a boolean argument, sets whether the MySQL ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-interfaceerror.html
This exception is raised for errors originating from Connector/Python itself, not related to the MySQL server.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-operationalerror.html
This exception is raised for errors which are related to MySQL's operations. For example: too many connections; a host name could not be resolved; bad handshake; server is shutting down, communication errors.
https://dev.mysql.com/doc/connector-python/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/connector-python/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/connector-python/en/connector-python-api-mysqlconnection-get-row.html
This method retrieves the next row of a query result set, returning a tuple. The tuple returned by get_row() consists of: The row as a tuple containing byte objects, or None when no more rows are available. EOF packet information as a dictionary ...