Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-last-insert-id.html
Obtaining the value of column that uses AUTO_INCREMENT after an INSERT statement can be achieved in a number of different ways. To obtain the value immediately after an INSERT, use a SELECT query with the LAST_INSERT_ID() function. For example, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-affected-rows.html
Syntax: count = ccnx.affected_rows() Returns the number of rows changed, inserted, or deleted by the most recent UPDATE, INSERT, or DELETE statement.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-character-set-name.html
Syntax: charset = ccnx.character_set_name() Returns the name of the default character set for the current MySQL session. When this is the case, a name usable by Python is returned. For example, the 'utf8mb4' MySQL character set name is returned as ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-consume-result.html
Syntax: ccnx.consume_result() Consumes the stored result set, if there is one, for this MySQL instance, by fetching all rows. If the statement that was executed returned multiple result sets, this method loops over and consumes all of them.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-fetch-fields.html
Syntax: field_info = ccnx.fetch_fields() Fetches column information for the active result set. Returns a list of tuples, one tuple per column Raises a MySQLInterfaceError exception for any MySQL error returned by the MySQL server.
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-get-proto-info.html
Syntax: info = ccnx.get_proto_info() Returns the protocol version used by the current session.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-insert-id.html
Syntax: insert_id = ccnx.insert_id() Returns the AUTO_INCREMENT value generated by the most recent executed statement, or 0 if there is no such value.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-next-result.html
Syntax: ccnx.next_result() Initiates the next result set for a statement string that produced multiple result sets. Raises a MySQLInterfaceError exception for any MySQL error returned by the MySQL server.
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() ...