pydoc > MySQLdb

📘 NAME

MySQLdb - MySQLdb - A DB API v2.0 compatible interface to MySQL.

🚀 Quick Reference

Use CaseCommandDescription
🔗 Connect to MySQLConnect(*args, **kwargs)Factory function for connections.Connection.
🔒 Escape SQL stringescape_string(s)Quote SQL-interpreted characters in string s.
📝 String literalstring_literal(obj)Convert object to SQL string literal (escaped + quoted).
📅 Date from ticksDateFromTicks(ticks)Convert UNIX ticks into a date instance.
⏰ Time from ticksTimeFromTicks(ticks)Convert UNIX ticks into a time instance.
📅⏰ Timestamp from ticksTimestampFromTicks(ticks)Convert UNIX ticks into a datetime instance.
🐛 Debug pushdebug(s)DBUG_PUSH with given string (requires debug client library).
â„šī¸ Client infoget_client_info()Returns client library version string.

📖 DESCRIPTION

This package is a wrapper around _mysql, which mostly implements the MySQL C API.

connect() — connects to server

See the C API specification and the MySQL documentation for more info on other items.

For information on how MySQLdb handles type conversion, see the MySQLdb.converters module.

đŸ“Ļ PACKAGE CONTENTS

📁 SUBMODULES

đŸˇī¸ CLASSES

🐍 class DBAPISet

class DBAPISet(builtins.frozenset)

A special type of set for which A == x is true if A is a DBAPISet and x is a member of that set.

Method resolution order: DBAPISet, builtins.frozenset, builtins.object

Methods inherited from builtins.frozenset:

Class methods inherited from builtins.frozenset:

Static methods inherited from builtins.frozenset:

🐍 class DataError

class DataError(DatabaseError)

Exception raised for errors that are due to problems with the processed data like division by zero, numeric value out of range, etc.

Method resolution order: DataError, DatabaseError, Error, MySQLError, builtins.Exception, builtins.BaseException, builtins.object

Methods inherited from builtins.BaseException:

Data descriptors inherited from builtins.BaseException:

🐍 class DatabaseError

class DatabaseError(Error)

Exception raised for errors that are related to the database.

Method resolution order: DatabaseError, Error, MySQLError, builtins.Exception, builtins.BaseException, builtins.object

Methods inherited from builtins.BaseException:

Data descriptors inherited from builtins.BaseException:

🐍 class Date (datetime.date)

class date(builtins.object)

date(year, month, day) --> date object

Class methods:

Static methods:

Data descriptors:

Data attributes:

🐍 class Error

class Error(MySQLError)

Exception that is the base class of all other error exceptions (not Warning).

Method resolution order: Error, MySQLError, builtins.Exception, builtins.BaseException, builtins.object

Methods inherited from builtins.BaseException:

Data descriptors inherited from builtins.BaseException:

🐍 class IntegrityError

class IntegrityError(DatabaseError)

Exception raised when the relational integrity of the database is affected, e.g. a foreign key check fails, duplicate key, etc.

Method resolution order: IntegrityError, DatabaseError, Error, MySQLError, builtins.Exception, builtins.BaseException, builtins.object

Methods inherited from builtins.BaseException:

Data descriptors inherited from builtins.BaseException:

🐍 class InterfaceError

class InterfaceError(Error)

Exception raised for errors that are related to the database interface rather than the database itself.

Method resolution order: InterfaceError, Error, MySQLError, builtins.Exception, builtins.BaseException, builtins.object

Methods inherited from builtins.BaseException:

Data descriptors inherited from builtins.BaseException:

🐍 class InternalError

class InternalError(DatabaseError)

Exception raised when the database encounters an internal error, e.g. the cursor is not valid anymore, the transaction is out of sync, etc.

Method resolution order: InternalError, DatabaseError, Error, MySQLError, builtins.Exception, builtins.BaseException, builtins.object

Methods inherited from builtins.BaseException:

Data descriptors inherited from builtins.BaseException:

🐍 class MySQLError

class MySQLError(builtins.Exception)

Exception related to operation with MySQL.

Method resolution order: MySQLError, builtins.Exception, builtins.BaseException, builtins.object

Methods inherited from builtins.BaseException:

Data descriptors inherited from builtins.BaseException:

🐍 class NotSupportedError

class NotSupportedError(DatabaseError)

Exception raised in case a method or database API was used which is not supported by the database, e.g. requesting a .rollback() on a connection that does not support transaction.

Method resolution order: NotSupportedError, DatabaseError, Error, MySQLError, builtins.Exception, builtins.BaseException, builtins.object

Methods inherited from builtins.BaseException:

Data descriptors inherited from builtins.BaseException:

🐍 class OperationalError

class OperationalError(DatabaseError)

Exception raised for errors that are related to the database's operation and not necessarily under the control of the programmer, e.g. unexpected disconnect, data source name not found, transaction could not be processed, etc.

Method resolution order: OperationalError, DatabaseError, Error, MySQLError, builtins.Exception, builtins.BaseException, builtins.object

Methods inherited from builtins.BaseException:

Data descriptors inherited from builtins.BaseException:

🐍 class ProgrammingError

class ProgrammingError(DatabaseError)

Exception raised for programming errors, e.g. table not found or already exists, syntax error in SQL statement, wrong number of parameters, etc.

Method resolution order: ProgrammingError, DatabaseError, Error, MySQLError, builtins.Exception, builtins.BaseException, builtins.object

Methods inherited from builtins.BaseException:

Data descriptors inherited from builtins.BaseException:

🐍 class Time (datetime.time)

class time(builtins.object)

time([hour[, minute[, second[, microsecond[, tzinfo]]]]]) --> a time object

Class methods:

Static methods:

Data descriptors:

Data attributes:

🐍 class Timestamp (datetime.datetime)

class datetime(date)

datetime(year, month, day[, hour[, minute[, second[, microsecond[,tzinfo]]]]])

Class methods:

Static methods:

Data descriptors:

Data attributes:

Methods inherited from date:

Class methods inherited from date:

Data descriptors inherited from date:

🐍 class Warning

class Warning(builtins.Warning, MySQLError)

Exception raised for important warnings like data truncations while inserting, etc.

Method resolution order: Warning, builtins.Warning, MySQLError, builtins.Exception, builtins.BaseException, builtins.object

Methods inherited from builtins.BaseException:

Data descriptors inherited from builtins.BaseException:

🔧 FUNCTIONS

📊 DATA

đŸˇī¸ VERSION

1.4.6

👤 AUTHOR

Inada Naoki <songofacandy AT gmail.com>

📄 FILE

/usr/lib/python3/dist-packages/MySQLdb/__init__.py

MySQLdb
📘 NAME 🚀 Quick Reference 📖 DESCRIPTION đŸ“Ļ PACKAGE CONTENTS 📁 SUBMODULES đŸˇī¸ CLASSES
🐍 class DBAPISet 🐍 class DataError 🐍 class DatabaseError 🐍 class Date (datetime.date) 🐍 class Error 🐍 class IntegrityError 🐍 class InterfaceError 🐍 class InternalError 🐍 class MySQLError 🐍 class NotSupportedError 🐍 class OperationalError 🐍 class ProgrammingError 🐍 class Time (datetime.time) 🐍 class Timestamp (datetime.datetime) 🐍 class Warning
🔧 FUNCTIONS 📊 DATA đŸˇī¸ VERSION 👤 AUTHOR 📄 FILE

Generated by phpman v4.10.0-7-g98e9fd5 · Markdown · JSON · MCP Author: Che Dong Under GNU General Public License
2026-09-01 18:49 @216.73.216.239
CrawledBy Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Valid XHTML 1.0 Transitional!Valid CSS!

^_top_^