Module Hierarchy

• MySQLdb: MySQLdb - A DB API v2.0 compatible interface to MySQL.
  • connections: This module implements connections for MySQLdb.
  • constants
    • CLIENT: MySQL CLIENT constants
    • CR: MySQL Connection Errors
    • ER: MySQL ER Constants
    • FIELD_TYPE: MySQL FIELD_TYPE Constants
    • FLAG: MySQL FLAG Constants
    • REFRESH: MySQL REFRESH Constants
  • converters: MySQLdb type conversion module
  • cursors: MySQLdb Cursors
  • release
  • times: times module
• _mysql: an adaptation of the MySQL C API (mostly)
• _mysql_exceptions: _mysql_exceptions: Exception classes for _mysql and MySQLdb.

Class Hierarchy

• __builtin__.object: The most base type
  • MySQLdb.cursors.BaseCursor: A base for Cursor classes.
    • MySQLdb.cursors.Cursor: This is the standard Cursor class that returns rows as tuples and stores the result set in the client.
    • MySQLdb.cursors.DictCursor: This is a Cursor class that returns rows as dictionaries and stores the result set in the client.
    • MySQLdb.cursors.SSCursor: This is a Cursor class that returns rows as tuples and stores the result set in the server.
    • MySQLdb.cursors.SSDictCursor: This is a Cursor class that returns rows as dictionaries and stores the result set in the server.
  • sets.BaseSet: Common base class for mutable and immutable sets.
    • sets.ImmutableSet: Immutable set class.
      • MySQLdb.DBAPISet: A special type of set for which A == x is true if A is a DBAPISet and x is a member of that set.
  • MySQLdb.cursors.CursorDictRowsMixIn: This is a MixIn class that causes all rows to be returned as dictionaries.
    • MySQLdb.cursors.CursorOldDictRowsMixIn: This is a MixIn class that returns rows as dictionaries with the same key convention as the old Mysqldb (MySQLmodule).
    • MySQLdb.cursors.DictCursor: This is a Cursor class that returns rows as dictionaries and stores the result set in the client.
    • MySQLdb.cursors.SSDictCursor: This is a Cursor class that returns rows as dictionaries and stores the result set in the server.
  • MySQLdb.cursors.CursorStoreResultMixIn: This is a MixIn class which causes the entire result set to be stored on the client side, i.e.
    • MySQLdb.cursors.Cursor: This is the standard Cursor class that returns rows as tuples and stores the result set in the client.
    • MySQLdb.cursors.DictCursor: This is a Cursor class that returns rows as dictionaries and stores the result set in the client.
  • MySQLdb.cursors.CursorTupleRowsMixIn: This is a MixIn class that causes all rows to be returned as tuples, which is the standard form required by DB API.
    • MySQLdb.cursors.Cursor: This is the standard Cursor class that returns rows as tuples and stores the result set in the client.
    • MySQLdb.cursors.SSCursor: This is a Cursor class that returns rows as tuples and stores the result set in the server.
  • MySQLdb.cursors.CursorUseResultMixIn: This is a MixIn class which causes the result set to be stored in the server and sent row-by-row to client side, i.e.
    • MySQLdb.cursors.SSCursor: This is a Cursor class that returns rows as tuples and stores the result set in the server.
    • MySQLdb.cursors.SSDictCursor: This is a Cursor class that returns rows as dictionaries and stores the result set in the server.
  • __builtin__.type: type(object) -> the object's type type(name, bases, dict) -> a new type
  • _mysql.connection: Returns a MYSQL connection object.
    • MySQLdb.connections.Connection: MySQL Database Connection Object
  • _mysql.result: result(connection, use=0, converter={}) -- Result set from a query.
• exceptions.Exception: Common base class for all exceptions.
  • exceptions.StandardError: Base class for all standard Python exceptions.
    • _mysql_exceptions.MySQLError: Exception related to operation with MySQL.
      • _mysql_exceptions.Error: Exception that is the base class of all other error exceptions (not Warning).
        • _mysql_exceptions.DatabaseError: Exception raised for errors that are related to the database.
          • _mysql_exceptions.DataError: Exception raised for errors that are due to problems with the processed data like division by zero, numeric value out of range, etc.
          • _mysql_exceptions.IntegrityError: Exception raised when the relational integrity of the database is affected, e.g.
          • _mysql_exceptions.InternalError: Exception raised when the database encounters an internal error, e.g.
          • _mysql_exceptions.NotSupportedError: Exception raised in case a method or database API was used which is not supported by the database, e.g.
          • _mysql_exceptions.OperationalError: Exception raised for errors that are related to the database's operation and not necessarily under the control of the programmer, e.g.
          • _mysql_exceptions.ProgrammingError: Exception raised for programming errors, e.g.
        • _mysql_exceptions.InterfaceError: Exception raised for errors that are related to the database interface rather than the database itself.
      • _mysql_exceptions.Warning: Exception raised for important warnings like data truncations while inserting, etc.
  • exceptions.Warning: Base class for warning categories.
    • _mysql_exceptions.Warning: Exception raised for important warnings like data truncations while inserting, etc.