Documentation Home
MySQL Connector/Python Developer Guide
Related Documentation Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb


10.5.1 cursor.MySQLCursor Constructor

In most cases, theMySQLConnectioncursor() method is used to instantiate aMySQLCursor object:

import mysql.connectorcnx = mysql.connector.connect(database='world')cursor = cnx.cursor()

It is also possible to instantiate a cursor by passing aMySQLConnection object toMySQLCursor:

import mysql.connectorfrom mysql.connector.cursor import MySQLCursorcnx = mysql.connector.connect(database='world')cursor = MySQLCursor(cnx)

The connection argument is optional. If omitted, the cursor is created but itsexecute() method raises an exception.