I have mysql database updated daily with Python and database structure is created like this:
# dt is date time in following format ("%Y-%m-%d %H:%M:%S")
dt_date = [login to view URL]()
dt = [login to view URL]("%Y-%m-%d %H:%M:%S")
# Create database – to be used only one time
[login to view URL]("CREATE TABLE country001 (dt VARCHAR(50),total VARCHAR(50))")
#Insert data to database
[login to view URL]("INSERT INTO country001 (dt, total) VALUES (%s,%s)", (dt, total))
However I can change database structure if this will help to make it easier. All I need is “total” number presented on chart.
Bu iş için 24 freelancer ortalamada $169 teklif veriyor
I'm a senior Python & ML developer and owner & founder of Dedeoglu Dev Company. Kindly send me a message to get in touch with me, Thanks, Yusuf.
I have done similar work in the past. As per my skills, I am the right one for this project and I will provide you with much better service and timely support.