Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-escape-string.html
Raises a TypeError exception if the value does not have a Unicode, bytes, or (for Python 2) string type. Syntax: str = ccnx.escape_string(str_to_escape) Uses the mysql_escape_string() C API function to create an SQL string that you can use in an ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-programmingerror.html
This exception is raised on programming errors, for example when you have a syntax error in your SQL or a table was not found. The following example shows how to handle syntax errors: try: cursor.execute("CREATE DESK t1 (id int, PRIMARY KEY (id))") ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-debug.html
Instructs the server to write debugging information to the error log.
https://dev.mysql.com/doc/connector-python/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/connector-python/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/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-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/connector-python/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 10.2.52, “MySQLConnection.sql_mode Property”). This property can be assigned a value of True or False to ...
https://dev.mysql.com/doc/connector-python/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/connector-python/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 ...