(base) ➜ Documents conda activate ak_test(ak_test) ➜ Documents pythonPython 3.8.5 (default, Sep 4 , 02:22:02) [Clang 10.0.0 ] :: Anaconda, Inc. on darwinType "help", "copyright", "credits" or "license" for more information.>>> from sqlalchemy import create_engineTraceback (most recent call last):File "<stdin>", line 1, in <module>ModuleNotFoundError: No module named 'sqlalchemy'(ak_test) ➜ Documents pip install SQLAlchemy Flask-SQLAlchemy(ak_test) ➜ Documents pythonPython 3.8.5 (default, Sep 4 , 02:22:02) [Clang 10.0.0 ] :: Anaconda, Inc. on darwinType "help", "copyright", "credits" or "license" for more information.>>> from sqlalchemy import create_engine>>> import pymysqlTraceback (most recent call last):File "<stdin>", line 1, in <module>ModuleNotFoundError: No module named 'pymysql'(ak_test) ➜ Documents pip3 install pymysqlmysql -hlocalhost -uroot -pZwh12345 -P3306 -A 可连接成功。ps:mysql 的密码不要带@号，会影响下面案例的连接
Example – Write Pandas DataFrame into a MySQL Database Table:
/pandas/serialization/mysql
from sqlalchemy import create_engineimport pymysqlimport pandas as pduserVitals = {"UserId":["xxxxx", "yyyyy", "zzzzz", "aaaaa", "bbbbb", "ccccc", "ddddd"],"UserFavourite":["Greek Salad", "Philly Cheese Steak", "Turkey Burger", "Crispy Orange Chicken", "Atlantic Salmon", "Pot roast", "Banana split"],"MonthlyOrderFrequency":[5, 1, 2, 2, 7, 6, 1],"HighestOrderAmount":[30, 20, 16, 23, 20, 26, 9],"LastOrderAmount":[21,20,4,11,7,7,7],"LastOrderRating":[3,3,3,2,3,2,4],"AverageOrderRating":[3,4,2,1,3,4,3],"OrderMode":["Web", "App", "App", "App", "Web", "Web", "App"],"InMedicalCare":["No", "No", "No", "No", "Yes", "No", "No"]};tableName = "UserVitals"dataFrame = pd.DataFrame(data=userVitals) sqlEngine = create_engine('mysql+pymysql://root:Zwh12345@localhost:3306/test') #要提前建好test库dbConnection = sqlEngine.connect()frame = dataFrame.to_sql(tableName, dbConnection, if_exists='fail');dbConnection.close()
参考链接：
/en/14/dialects/mysql.html
效果：
