Hi Everyone, How do I run mysql queries in solid? How do i establish mysql connection? should I have to use pymysql library or any other library?
06/16/2021, 7:27 AM
Hi, I believe one can use SQLAlchemy
06/16/2021, 8:38 AM
@Peter B how can I pass database parameters to establish mysql connection using resource?
06/16/2021, 10:45 PM
Lookup psycopg2, and SQL alchemy, the documentation will help. Or, if you’d like to keep it simple, use Pandas’ ‘to_sql’ method, and use SQL alchemy to create the ‘engine’ off your database connection string first. See how you go, I’ll be on my computer tomorrow I can paste an example.
Get Outlook for iOS