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-process-kill.html
The following two lines have the same effect: >>> cnx.cmd_process_kill(123) >>> cnx.cmd_query('KILL 123') . Although still available, it is better to use the KILL SQL statement.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-refresh.html
This method flushes tables or caches, or resets replication server information. The options argument should be a bitmask value constructed using constants from the constants.RefreshOption class. Example: >>> from mysql.connector import RefreshOption ...
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-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-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-mysqlconnectionpool-constructor.html
It is not an error for multiple pools to have the same name. Syntax: MySQLConnectionPool(pool_name=None, pool_size=5, pool_reset_session=True, **kwargs) This constructor instantiates an object that manages a connection pool. If this argument is not ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-rowcount.html
For nonbuffered cursors, the row count cannot be known before the rows have been fetched. 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 ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-with-rows.html
Syntax: boolean = cursor.with_rows This read-only property returns True or False to indicate whether the most recently executed operation could have produced rows. The with_rows property is useful when it is necessary to determine whether a ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-select.html
Note that we are using unquoted %s-markers where dates should have been. The following example shows how to query data using a cursor created using the connection's cursor() method. The task is to select all employees hired in the year 1999 and ...