mysql 生成报表

import mysql.connector
from mysql.connector import Error

def generate_report():
    try:
        connection = mysql.connector.connect(host='localhost',
                                             database='testdb',
                                             user='root',
                                             password='password')

        if connection.is_connected():
            cursor = connection.cursor()
            cursor.execute("SELECT * FROM sales_data")

            report_data = cursor.fetchall()

            for row in report_data:
                print(row)

    except Error as e:
        print("Error while connecting to MySQL", e)

    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

generate_report()