Access specific table from MySQL database with Python

Question

I have a MySQL database named my_database , and it that database there are a lot of tables. I want to connect MySQL with Python and to work with specific table named my_table from that database.

This is the code that I have for now:

import json

import pymysql

connection = pymysql.connect(user = "root", password = "", host = "127.0.0.1", port = "", database = "my_database")

cursor = connection.cursor()

print(cursor.execute("SELECT * FROM my_database.my_table"))

This code returns number of rows, but I want to get all columns and rows (all values from that table). I have also tried SELECT * FROM my_table but result is the same.

Answer 1

To get all the columns and rows returned by the execution of the query, you need to use  fetchall() methods.

add this at the end of your code.

cursor.execute("SELECT * FROM my_database.my_table")

rows = cursor.fetchall()

for row in rows:

    print(row)