Inserting values into MySQL database via SSH in Python works only temporarily

QuestionsInserting values into MySQL database via SSH in Python works only temporarily
sethbeckerman5 Staff asked 4 years ago

For a university project I rented a server to run a MySQL database on it. In Python, I connect to the server via SSH (I know, not the best solution) and try to insert values into a table in the database. If I run the statement and then directly (in my Python program), I get back the inserted value. If I run my program a second time without the statement, the value is not displayed. Also, when I look in the database table, the value was not inserted.
Here my code:

Solution:
Add to database connection


View on Stack Overflow