Database Connection in Python

Categories: Python

Before connecting to a MySQL database, make sure of the followings −

You have created a database TESTDB.

You have created a table EMPLOYEE in TESTDB.

This table has fields FIRST_NAME, LAST_NAME, AGE, SEX and INCOME.

User ID "testuser" and password "test123" are set to access TESTDB.

Python module MySQLdb is installed properly on your machine.

You have gone through MySQL tutorial to understand MySQL Basics.

While running this script, it is producing the following result in my Linux machine.

Database version : 5.0.45

If a connection is established with the datasource, then a Connection Object is returned and saved into db for further use, otherwise db is set to None. Next, db object is used to create a cursor object, which in turn is used to execute SQL queries. Finally, before coming out, it ensures that database connection is closed and resources are released.

Top articles
What is used of Python? Some uses with practical Python Published at:- Some Advanced Features of Python and Its uses Published at:- Python Interview Question and Answer Published at:- Python Introduction Published at:- Benefits of Python Programming Language Published at:- Introduction to Careers in Python Published at:- Advantages of Python Published at:- AWS Control Tower now supports Python 3.9 runtime Published at:- Hello World using Python Program. Published at:- Features of Python Published at:- History of Python Published at:- Loper al Environment Setup of Python Published at:- Getting Python on the Appliper ation Published at:- Python Identifiers Published at:- Lines and Indentation in the Python Published at:- Multi-Line Statements in the python Published at:- Quotation in Python Published at:- Comments in Python Published at:- Using Blank Lines in Python Published at:- Assigning Values to Variables in the Python Published at:- Multiple Assignment in the Python Published at:- Standard Data Types Published at:- Python Comment Published at:- Multiple Python Statement in One Line on the Comment Published at:- Strings Python Statements In Comment Published at:- Python Indentation Published at:- What are Python Variables? Published at:- Python Strings Published at:- Python String Program Published at:- Python Lists Published at:- Python Tuples Published at:- Python Dictionary Published at:- Data Type Conversion Published at:- Different Types of Operators in the Python Published at:- Python Arithmetic Operators Published at:- Python Comparison Operators Published at:- Python Assignment Operators Published at:- Python Bitwise Operators Published at:- Python Logical Operators Published at:- Python Membership Operators Published at:- Python Identity Operators Published at:- Highest Precedence in Python Operators Published at:- Python - Decision Making Published at:- Single Statement In Python Published at:- Functions in Python Published at:- Defining a Function Published at:- Syntax in Python Published at:- Example of Python Published at:- Calling a Function Published at:- Function Arguments Published at:- Required arguments Published at:- Keyword arguments Published at:- Default arguments Published at:- Variable-length arguments Published at:- The Anonymous Functions Published at:- The return Statement Published at:- Scope of Variables Published at:- Global vs. Local variables Published at:- Default arguments Published at:- Variable-length arguments Published at:- The Anonymous Functions Published at:- The return Statement Published at:- Python - Modules Published at:- The import Statement Published at:- Locating Modules Published at:- The PYTHONPATH Variable Published at:- Namespaces and Scoping Published at:- The dir( ) Function Published at:- The globals() and locals() Functions Published at:- The reload() Function Published at:- Packages in Python Published at:- Python - Files I O Published at:- The raw_input Function Published at:- The input Function Published at:- Opening and Closing Files Published at:- The open Function Published at:- The file Object Attributes Published at:- The close() Method Published at:- Reading and Writing Files Published at:- The read() Method Published at:- File Positions Published at:- Renaming and Deleting Files Published at:- The remove() Method Published at:- Directories in Python Published at:- The chdir() Method Published at:- The getcwd() Method Published at:- The rmdir() Method Published at:- File & Directory Related Methods Published at:- Python - Exceptions Handling Published at:- Assertions in Python Published at:- The assert Statement Published at:- What is Exception? Published at:- Handling an exception Published at:- Argument of an Exception Published at:- Raising an Exceptions Published at:- User-Defined Exceptions Published at:- Python - Object Oriented Published at:- Overview of OOP Terminology Published at:- Creating Classes Published at:- Creating Instance Objects Published at:- Accessing Attributes Published at:- Built-In Class Attributes Published at:- Destroying Objects Published at:- Class Inheritance in Python Published at:- Base Overloading Methods Published at:- Overloading Operators in Python Published at:- Data Hiding Published at:- Python - Object Oriented Published at:- Creating Instance Objects Published at:- Accessing Attributes Published at:- Built-In Class Attributes Published at:- Class Inheritance Published at:- Python - CGI Programming Published at:- Web Browsing in Python Published at:- Web Server Support and Configuration In Python Published at:- HTTP Header In Python Published at:- CGI Environment Variables Published at:- Passing Information using GET method Published at:- Simple FORM Example:GET Method In Python Published at:- Passing Information Using POST Method In Python Published at:- Passing Radio Button Data to CGI Program Published at:- Passing Text Area Data to CGI Program Published at:- Using Cookies in CGI Published at:- How It Works In Python ? Published at:- Setting up Cookies In Python Published at:- How To Raise a "File Download" Dialog Box? Published at:- Python - MySQL Database Access Published at:- What is MySQLdb? Published at:- Database Connection In Python Published at:- Creating Database Table In Python Published at:- Python - Regular Expressions Published at:- The match Function Published at:- Regular Expression Modifiers: Option Flags Published at:- Regular Expression Patterns Published at:- What is Sockets? Published at:- The socket Module Published at:- Server Socket Methods Published at:- General Socket Methods Published at:- What is Simple Server Published at:- A Simple Client Published at:- Python Internet modules Published at:- Further Readings Published at:- Python - Sending Email using SMTP Published at:- Sending an HTML e-mail using Python Published at:- Sending Attachments as an E-mail Published at:- Python - Multithreaded Programming Published at:- Starting a New Thread Published at:- Python Lambda Published at:- Python Dictionaries Published at:- Ordered or Unordered? Published at:- Python Casting Published at:- What is an Array? Published at:- Python Iterators Published at:- Python Scope Published at:- Global Scope Published at:- Python Dates Published at:- What is PIP? Published at:- File Handling Published at:- Python File Open Published at:- Python File Write Published at:- NumPy Tutorial Published at:- Python - MySQL Database Access Published at:- What is MySQLdb? Published at:- Database Connection in Python Published at:- READ Operation Published at:- Python Tools Utilities Published at:- Python - Multithreaded Programming Published at:- Synchronizing Threads Published at:- Python - XML Processing Published at:- Python - GUI Programming Published at:-
R4Rin Team
The content on R4Rin.com website is created by expert teams.