Skip to content
Related Articles

Related Articles

How to Print Out All Rows of a MySQL Table in Python?
  • Last Updated : 26 Nov, 2020

MySQL server is an open-source relational database management system which is a major support for web-based applications. Databases and related tables are the main component of many websites and applications as the data is stored and exchanged over the web.  In order to access MySQL databases from a web server(here XAMPP) we use various modules in Python such as PyMySQL, mysql.connector, etc. 

In this article, we will see how to get the all rows of a MySQL table by making a database connection between python and MySQL.

First, we are going to connect to a database having a MySQL table. The SQL query to be used to get all the rows:

SELECT * FROM table-name 

 Finally, after getting all the rows, display each row in the table using an iterator.

Below are some programs which depict how to extract rows from a MySQL table in a Database:



Example 1:

Below is the table geeksdemo is database geek which is going to be accessed by a Python script:

Below is the program to get all the rows in an MYSQL table:

Python3




# import required modules
import pymysql
pymysql.install_as_MySQLdb()
import MySQLdb
  
# connect python with mysql with your hostname, 
# username, password and database
db= MySQLdb.connect("localhost", "root", "", "GEEK")
  
# get cursor object
cursor= db.cursor()
  
# execute your query
cursor.execute("SELECT * FROM geeksdemo")
  
# fetch all the matching rows 
result = cursor.fetchall()
  
# loop through the rows
for row in result:
    print(row)
    print("\n")

Output:

Example 2:



Here is another example to extracts all the rows from a table in a given database, below is the table scheme and rows:

Below is the Python script extract all each row from the table:

Python3




# import required modules
import MySQLdb
import pymysql
pymysql.install_as_MySQLdb()
  
# connect python with mysql with your hostname,
# username, password and database
db = MySQLdb.connect("localhost", "root", "", "techgeeks")
  
# get cursor object
cursor = db.cursor()
  
# execute your query
cursor.execute("SELECT * FROM techcompanies")
  
# fetch all the matching rows
result = cursor.fetchall()
  
# loop through the rows
for row in result:
    print(row, '\n')

Output:


Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.

My Personal Notes arrow_drop_up
Recommended Articles
Page :