Insert data to SQL through pymysql and flask

[iainstott]

what datatype are On and Off columns in your database table? If you execute the above statement in the DB console does it work?

---

Also your column name On is problem, as ON is reserved word in MySQL

INSERT INTO Monday (Program, OnState, Off) VALUES (2,'0:00:00','0:00:00')

should work. Note that I changed the column name, as well added single quotes around time values 

Dude, the amount of beer I owe you is incredible, changed column name and worked first time. Thank you.

Finally - I think your code can be simplified substantially

I know, I just wanted to get the base features working then I'll go back and evalute it.
Many thanks again