Skip to content

Instantly share code, notes, and snippets.

@madan712
madan712 / export_db.py
Last active October 6, 2024 07:54
Python - export mysql table to excel file
import xlsxwriter
import mysql.connector
def fetch_table_data(table_name):
# The connect() constructor creates a connection to the MySQL server and returns a MySQLConnection object.
cnx = mysql.connector.connect(
host='localhost',
database='schema',
user='user',