MySQL Connector/Python
Section Navigation [Toggle]
- MySQL Connector/Python
Abstract
This manual describes how to install, configure, and develop database applications using MySQL Connector/Python, a self-contained Python driver for communicating with MySQL servers.
For release notes detailing the changes in each release of Connector/Python, see http://dev.mysql.com/doc/relnotes/connector-python/en/.
Document generated on: 2013-01-01 (revision: 33781)
Table of Contents [+/-]
- Preface and Legal Notices
- 1. MySQL Connector/Python
- 2. Connector/Python Versions
- 3. Connector/Python Installation [+/-]
- 4. Connector/Python Coding Examples [+/-]
- 5. Connector/Python Tutorials [+/-]
- 6. Connector/Python Connection Arguments
- 7. Connector/Python API Reference [+/-]
- 7.1. Errors and Exceptions [+/-]
- 7.1.1. Module
errorcode - 7.1.2. Exception
errors.Error - 7.1.3. Exception
errors.Warning - 7.1.4. Exception
errors.InterfaceError - 7.1.5. Exception
errors.DatabaseError - 7.1.6. Exception
errors.InternalError - 7.1.7. Exception
errors.OperationalError - 7.1.8. Exception
errors.ProgrammingError - 7.1.9. Exception
errors.IntegrityError - 7.1.10. Exception
errors.DataError - 7.1.11. Exception
errors.NotSupportedError - 7.1.12. Function
errors.custom_error_exception(error=None, exception=None)
- 7.1.1. Module
- 7.2. Class
connection.MySQLConnection[+/-] - 7.2.1. Constructor
connection.MySQLConnection(**kwargs) - 7.2.2. Method
MySQLConnection.close() - 7.2.3. Method
MySQLConnection.config(**kwargs) - 7.2.4. Method
MySQLConnection.connect(**kwargs) - 7.2.5. Method
MySQLConnection.commit() - 7.2.6. Method
MySQLConnection.cursor(buffered=None, raw=None, cursor_class=None) - 7.2.7. Method
MySQLConnection.cmd_change_user(username='', password='', database='', charset=33) - 7.2.8. Method
MySQLConnection.cmd_debug() - 7.2.9. Method
MySQLConnection.cmd_init_db(database) - 7.2.10. Method
MySQLConnection.cmd_ping() - 7.2.11. Method
MySQLConnection.cmd_process_info() - 7.2.12. Method
MySQLConnection.cmd_process_kill(mysql_pid) - 7.2.13. Method
MySQLConnection.cmd_quit() - 7.2.14. Method
MySQLConnection.cmd_query(statement) - 7.2.15. Method
MySQLConnection.cmd_query_iter(statement) - 7.2.16. Method
MySQLConnection.cmd_refresh(options) - 7.2.17. Method
MySQLConnection.cmd_shutdown() - 7.2.18. Method
MySQLConnection.cmd_statistics() - 7.2.19. Method
MySQLConnection.disconnect() - 7.2.20. Method
MySQLConnection.get_rows(count=None) - 7.2.21. Method
MySQLConnection.get_row() - 7.2.22. Method
MySQLConnection.get_server_info() - 7.2.23. Method
MySQLConnection.get_server_version() - 7.2.24. Method
MySQLConnection.is_connected() - 7.2.25. Method
MySQLConnection.isset_client_flag(flag) - 7.2.26. Method
MySQLConnection.ping(attempts=1, delay=0) - 7.2.27. Method
MySQLConnection.reconnect(attempts=1, delay=0) - 7.2.28. Method
MySQLConnection.rollback() - 7.2.29. Method
MySQLConnection.set_charset_collation(charset=None, collation=None) - 7.2.30. Method
MySQLConnection.set_client_flags(flags) - 7.2.31. Property
MySQLConnection.autocommit - 7.2.32. Property
MySQLConnection.charset_name - 7.2.33. Property
MySQLConnection.collation_name - 7.2.34. Property
MySQLConnection.connection_id - 7.2.35. Property
MySQLConnection.database - 7.2.36. Property
MySQLConnection.get_warnings - 7.2.37. Property
MySQLConnection.raise_on_warnings - 7.2.38. Property
MySQLConnection.server_host - 7.2.39. Property
MySQLConnection.server_port - 7.2.40. Property
MySQLConnection.sql_mode - 7.2.41. Property
MySQLConnection.time_zone - 7.2.42. Property
MySQLConnection.unix_socket - 7.2.43. Property
MySQLConnection.user
- 7.2.1. Constructor
- 7.3. Class
cursor.MySQLCursor[+/-] - 7.3.1. Constructor
cursor.MySQLCursor - 7.3.2. Method
MySQLCursor.callproc(procname, args=()) - 7.3.3. Method
MySQLCursor.close() - 7.3.4. Method
MySQLCursor.execute(operation, params=None, multi=False) - 7.3.5. Method
MySQLCursor.executemany(operation, seq_params) - 7.3.6. Method
MySQLCursor.fetchall() - 7.3.7. Method
MySQLCursor.fetchmany(size=1) - 7.3.8. Method
MySQLCursor.fetchone() - 7.3.9. Method
MySQLCursor.fetchwarnings() - 7.3.10. Method
MySQLCursor.stored_results() - 7.3.11. Property
MySQLCursor.column_names - 7.3.12. Property
MySQLCursor.statement - 7.3.13. Property
MySQLCursor.with_rows
- 7.3.1. Constructor
- 7.4. Class
cursor.MySQLCursorBuffered - 7.5. Class
constants.ClientFlag - 7.6. Class
constants.FieldType - 7.7. Class
constants.SQLMode - 7.8. Class
constants.CharacterSet - 7.9. Class
constants.RefreshOption
- A. Licenses for Third-Party Components [+/-]
- A.1.
dtoa.cLicense - A.2. Editline Library (
libedit) License - A.3.
FindGTest.cmakeLicense - A.4. Fred Fish's Dbug Library License
- A.5.
getargLicense - A.6. GNU General Public License Version 2.0, June 1991
- A.7. GNU Lesser General Public License Version 2.1, February 1999
- A.8. GNU Libtool License
- A.9. GNU Readline License
- A.10. Google Controlling Master Thread I/O Rate Patch License
- A.11. Google Perftools (TCMalloc utility) License
- A.12. Google SMP Patch License
- A.13.
lib_sql.ccLicense - A.14. Libaio License
- A.15.
libeventLicense - A.16. Linux-PAM License
- A.17. md5 (Message-Digest Algorithm 5) License
- A.18. nt_servc (Windows NT Service class library) License
- A.19. OpenPAM License
- A.20. Percona Multiple I/O Threads Patch License
- A.21. Red HAT RPM Spec File License
- A.22. RegEX-Spencer Library License
- A.23. RFC 3174 - US Secure Hash Algorithm 1 (SHA1) License
- A.24. Richard A. O'Keefe String Library License
- A.25. SHA-1 in C License
- A.26.
zlibLicense
- A.1.
Copyright © 2012, Oracle and/or its affiliates. All rights
reserved.
Legal Notices
