Class Hierarchy

• object: The most base type
  • _mysql.connection: Returns a MYSQL connection object.
    • MySQLdb.connections.Connection: MySQL Database Connection Object
  • 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.SSDictCursor: This is a Cursor class that returns rows as dictionaries and stores the result set in the server.
    • MySQLdb.cursors.SSCursor: This is a Cursor class that returns rows as tuples and stores the result set in the server.
  • datetime.date: date(year, month, day) --> date object
    • datetime.datetime: datetime(year, month, day[, hour[, minute[, second[, microsecond[,tzinfo]]]]])
  • 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.SSDictCursor: This is a Cursor class that returns rows as dictionaries and stores the result set in the server.
    • MySQLdb.cursors.DictCursor: This is a Cursor class that returns rows as dictionaries and stores the result set in the client.
    • 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.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.SSCursor: This is a Cursor class that returns rows as tuples and stores the result set in the server.
    • MySQLdb.cursors.Cursor: This is the standard Cursor class that returns rows as tuples and stores the result set in the client.
  • datetime.time: time([hour[, minute[, second[, microsecond[, tzinfo]]]]]) --> a time object
  • MySQLdb.cursors.BaseCursor: A base for Cursor classes.
    • MySQLdb.cursors.SSDictCursor: This is a Cursor class that returns rows as dictionaries and stores the result set in the server.
    • MySQLdb.cursors.DictCursor: This is a Cursor class that returns rows as dictionaries and stores the result set in the client.
    • 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.CursorStoreResultMixIn: This is a MixIn class which causes the entire result set to be stored on the client side, i.e.
    • MySQLdb.cursors.DictCursor: This is a Cursor class that returns rows as dictionaries and stores the result set in the client.
    • MySQLdb.cursors.Cursor: This is the standard Cursor class that returns rows as tuples and stores the result set in the client.
  • exceptions.BaseException: Common base class for all exceptions
    • exceptions.Exception: Common base class for all non-exit exceptions.
      • exceptions.Warning: Base class for warning categories.
        • _mysql_exceptions.Warning: Exception raised for important warnings like data truncations while inserting, etc.
      • exceptions.StandardError: Base class for all standard Python exceptions that do not represent interpreter exiting.
        • _mysql_exceptions.MySQLError: Exception related to operation with MySQL.
          • _mysql_exceptions.Warning: Exception raised for important warnings like data truncations while inserting, etc.
          • _mysql_exceptions.Error: Exception that is the base class of all other error exceptions (not Warning).
            • _mysql_exceptions.InterfaceError: Exception raised for errors that are related to the database interface rather than the database itself.
            • _mysql_exceptions.DatabaseError: Exception raised for errors that are related to the database.
              • _mysql_exceptions.IntegrityError: Exception raised when the relational integrity of the database is affected, e.g.
              • _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.ProgrammingError: Exception raised for programming errors, 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.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.