mysql timeout重連 - jenhaoyang/backend_blog GitHub Wiki

範例:

    sql = ("INSERT INTO LOCATIONS (location_id, place_name) VALUES (%s, %s)")
    self.connnection.ping()  # reconnecting mysql
    with self.connection.cursor() as cursor:         
        cursor.execute(sql, (location_id, place_name))

參考: https://stackoverflow.com/a/61152360