Create line chart in browser based on mysql database

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 = datetime.now()
dt = dt_date.strftime("%Y-%m-%d %H:%M:%S")

# Create database – to be used only one time
mycursor.execute("CREATE TABLE country001 (dt VARCHAR(50),total VARCHAR(50))")

#Insert data to database
mycursor.execute("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.