Python MySQL - Select Query Last Updated : 28 Apr, 2025 Comments Improve Suggest changes 6 Likes Like Report See More Python Database API ( Application Program Interface ) is the Database interface for the standard Python. This standard is adhered to by most Python Database interfaces. There are various Database servers supported by Python Database such as MySQL, GadFly, mySQL, PostgreSQL, Microsoft SQL Server 2000, Informix, Interbase, Oracle, Sybase etc. To connect with MySQL database server from Python, we need to import the mysql.connector module. Below is a program to connect with MySQL database geeks. Python # importing required library import mysql.connector # connecting to the database dataBase = mysql.connector.connect( host = "localhost", user = "user", passwd = "pswrd", database = "geeks" ) # preparing a cursor object cursorObject = dataBase.cursor() # disconnecting from server dataBase.close() The above program illustrates the connection with the MySQL database geeks in which host-name is localhost, the username is user and password is pswrd. Select Query After connecting with the database in MySQL we can select queries from the tables in it. Syntax: In order to select particular attribute columns from a table, we write the attribute names.SELECT attr1, attr2 FROM table_nameIn order to select all the attribute columns from a table, we use the asterisk '*' symbol.SELECT * FROM table_name Example 1: Let's consider the table looks like this - Below is a program to select a query from the table in the database. Python # importing required library import mysql.connector # connecting to the database dataBase = mysql.connector.connect( host = "localhost", user = "user", passwd = "pswrd", database = "geeks" ) # preparing a cursor object cursorObject = dataBase.cursor() print("Displaying NAME and ROLL columns from the STUDENT table:") # selecting query query = "SELECT NAME, ROLL FROM STUDENT" cursorObject.execute(query) myresult = cursorObject.fetchall() for x in myresult: print(x) # disconnecting from server dataBase.close() Output: Example 2: Let us look at another example for selecting queries in a table. Python # importing required library import mysql.connector # connecting to the database dataBase = mysql.connector.connect( host = "localhost", user = "user", passwd = "pswrd", database = "geeks" ) # preparing a cursor object cursorObject = dataBase.cursor() print("Displaying NAME and ROLL columns from the STUDENT table:") # selecting query query = "SELECT * FROM STUDENT" cursorObject.execute(query) myresult = cursorObject.fetchall() for x in myresult: print(x) # disconnecting from server dataBase.close() Output: Create Quiz Comment R riturajsaha Follow 6 Improve R riturajsaha Follow 6 Improve Article Tags : Python Python-mySQL Explore Python FundamentalsPython Introduction 2 min read Input and Output in Python 4 min read Python Variables 4 min read Python Operators 4 min read Python Keywords 2 min read Python Data Types 8 min read Conditional Statements in Python 3 min read Loops in Python - For, While and Nested Loops 5 min read Python Functions 5 min read Recursion in Python 4 min read Python Lambda Functions 5 min read Python Data StructuresPython String 5 min read Python Lists 4 min read Python Tuples 4 min read Python Dictionary 3 min read Python Sets 6 min read Python Arrays 7 min read List Comprehension in Python 4 min read Advanced PythonPython OOP Concepts 11 min read Python Exception Handling 5 min read File Handling in Python 4 min read Python Database Tutorial 4 min read Python MongoDB Tutorial 3 min read Python MySQL 9 min read Python Packages 10 min read Python Modules 3 min read Python DSA Libraries 15 min read List of Python GUI Library and Packages 3 min read Data Science with PythonNumPy Tutorial - Python Library 3 min read Pandas Tutorial 4 min read Matplotlib Tutorial 5 min read Python Seaborn Tutorial 3 min read StatsModel Library - Tutorial 3 min read Learning Model Building in Scikit-learn 6 min read TensorFlow Tutorial 2 min read PyTorch Tutorial 6 min read Web Development with PythonFlask Tutorial 8 min read Django Tutorial | Learn Django Framework 7 min read Django ORM - Inserting, Updating & Deleting Data 4 min read Templating With Jinja2 in Flask 6 min read Django Templates 5 min read Build a REST API using Flask - Python 3 min read Building a Simple API with Django REST Framework 3 min read Python PracticePython Quiz 1 min read Python Coding Practice 1 min read Python Interview Questions and Answers 15+ min read Like