Unity Timeline extension Setting custom PlayableBehavio Track

2023-01-25  

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

source

Related Posts

Hive query sequence

Note Sorting 6 —— Implement IP traffic analysis with python

html-cssday1: CSS points supplementary instructions, project drills

4 QT’s Pro configue multiple sub -engineering/sub -modules

Unity Timeline extension Setting custom PlayableBehavio Track

Random Posts

Install Android Studio on MacBook

Design and realize a Servlet that receives the data of the client table

LA3263ThatniceEulerCircuits

Handwriting digital picture dual -value converted to 32*32 array.

[bzoj2732] [hnoi2012] Archery (two points+semi -plane interchange) CLOVE