from sqlalcheMy Import Create_engine
import pandas as pd
# Create database connection
engine = create_engine ('mysql: // root:[email protected]/testdb ')
# Read MySQL data
db = pd.read_sql (SQL = 'Select * from testdb.t1', con = Engine)
# Export data to Excel
db.to_excel ('testexportdata.xlsx')
MySQL connection string:
mysql: // User: [email protected]/testdb
Installation dependencies
pip install sqlalchemy
pip install pandas
pip install mysqlclient
Collecting mysqlclient
Downloading mysqlclient-2.1.1-cp310-cp310-win_amd64.whl (178 kB)
|████████████████████████████████| 178 kB 15 kB/s
Installing collected packages: mysqlclient
Successfully installed mysqlclient-2.1.1
WARNING: You are using pip version 21.1.2; however, version 22.2.1 is available.
pip install openpyxl
Collecting openpyxl
Downloading openpyxl-3.0.10-py2.py3-none-any.whl (242 kB)
|████████████████████████████████| 242 kB 94 kB/s
Collecting et-xmlfile
Downloading et_xmlfile-1.1.0-py3-none-any.whl (4.7 kB)
Installing collected packages: et-xmlfile, openpyxl
Successfully installed et-xmlfile-1.1.0 openpyxl-3.0.10
WARNING: You are using pip version 21.1.2; however, version 22.2.1 is available