unable to insert into mysql table using pyhton : I'm trying to insert rows in my sql table using a csv file in python.

There are five columns (id(autoincrement, primary, int),Event(int), Edition(int), Subscription(varchar), Daystogo(varchar)

My csv has 4 columns (Event, Edition, Subscription, Daystogo). I want to insert these into the table and let id be assigned in autoincremental way.

<!-- begin snippet: js hide: false console: true babel: false -->

<!-- language: lang-html -->

    mydb = mysql.connector.connect(
            user='user', password='password',
                                  host='host',
                                  database='opm')
    mycursor = mydb.cursor()

      
    csv_data=csv.reader("mycsvfile.csv")
    for row in csv_data:
    	print(row)
    	mycursor.execute("INSERT INTO opm (Event, Edition, Subscription, Daystogo) VALUES (%s,%s,%s,%s)", (int,int,str, str))


<!-- end snippet -->

This is the error that i have been receiving

<!-- begin snippet: js hide: false console: true babel: false -->

<!-- language: lang-html -->

    csv_data=csv.reader("mycsvfile.csv")
    for row in csv_data:
    	print(row)
    	mycursor.execute("INSERT INTO opm (Event, Edition, Subscription, Daystogo) VALUES (%s,%s,%s,%s)", (int,int,str, str))


    ['m']
    Traceback (most recent call last):

      File "<ipython-input-51-5b5e2c804099>", line 4, in <module>
        mycursor.execute("INSERT INTO opm (Event, Edition, Subscription, Daystogo) VALUES (%s,%s,%s,%s)", (int,int,str, str))

      File "E:\Data Science\pyWork\PyProjects\Program\lib\site-packages\mysql\connector\cursor.py", line 547, in execute
        psub = _ParamSubstitutor(self._process_params(params))

      File "E:\Data Science\pyWork\PyProjects\Program\lib\site-packages\mysql\connector\cursor.py", line 430, in _process_params
        "Failed processing format-parameters; %s" % err)

    ProgrammingError: Failed processing format-parameters; Python 'type' cannot be converted to a MySQL type

<!-- end snippet -->

Please help me out how can I insert the rows in mysql table
