How to insert data into pypyodbc SQL table?

Question

Python

I have a table like this:

And this is the code:

appr = int(input('Введите оценку: '))

mySQLQuery = (f'''
                    SELECT {subject}
                    FROM dbo.rating

                    insert into dbo.rating ({subject}) values ('{appr}')
                                    ''')
cursor.executemany(mySQLQuery)

After its execution, a new row appears in the table, where "id"=NULL, and I need it to add a rating to the existing row. If I remove the "id" column, then everything will work fine, but I need it to delete or change data in the table. Tell me how to solve this problem?!
PS variables "subject"-subject, "appr"-evaluation

Answer 1

Some kind of request you have is strange ... have you tried it separately? Add an id characteristic to auto_increment and see what happens

Answer 2

added a grade to an existing line

in SQL is called UPDATE

mySQLQuery = (f'''update dbo.rating set `{subject}` = {appr} where id = '{your_id}')''')

better by passing parameters

mySQLQuery = f'''update dbo.rating set `{subject}` = %s where id = %s'''
cursor.execute(mySQLQuery, (appr, your_id))