error when inserting list statement from python to MySQL

[ADBYITMS]

HI all i am trying to insert data from a python script i have and i am getting an error, i thank you for your help in advance and feel free to let me know if there is a better way to do what I am trying to do here , as i am still new to coding with python any help would be good, i will be adding other locations soon as please letme know if that would be best to do each with another file or all in the one

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72

import mysql.connector from requests_html import HTMLSession     # create an HTML Session object session = HTMLSession()   # Use the object above to connect to needed webpage resp = session.get("https://www.sydneyairport.com.au/flights/?query=&flightType=departure&terminalType=domestic&date=2019-11-05&sortColumn=scheduled_time&ascending=true&showAll=false")   # Run JavaScript code on webpage resp.html.render()   # parse <span class="with-image"> elements containing airline names airline_list = [] airline_spans = resp.html.find('.with-image') for span in airline_spans:     airline_list.append(span.text)   # parse <div class="city-name"> elements containing airline names dest_list = [] dest_divs = resp.html.find('.city-name') for span in dest_divs:     dest_list.append(span.text)   # parse <div class="flight-numbers"> elements containing Flight numbers flightnumber_list = [] flightnumber_divs = resp.html.find('.flight-numbers') for span in flightnumber_divs:     flightnumber_list.append(span.text)     # parse <div class="heading-large"> elements containing Sec depart time secdepartime_list = [] secdepartime_divs = resp.html.find('.large-scheduled-time') for span in secdepartime_divs:     secdepartime_list.append(span.text)     # parse <div class="estimated-time"> elements containing estimated-time estimatedtime_list = [] estimatedtime_divs = resp.html.find('.estimated-time') for span in estimatedtime_divs:     estimatedtime_list.append(span.text)   # parse <div class="estimated-time"> elements containing latesttime status_list = [] status_divs = resp.html.find('.status-container') for span in status_divs:     status_list.append(span.text)     #Connecting go the mysql database to store the infomation   mydb = mysql.connector.connect(   host="localhost",   user="root",   passwd="*******",   database="FlightData" ) print("Adding Sydney Domestic Airport Flight Information to the Database") mycursor = mydb.cursor() sql = "INSERT INTO FlightData (Origan, destination,Flight-Number, Airline, Scheduled,Estimated,Status ) VALUES (%s, %s)" val = ("Sydney", dest_list, flightnumber_list, airline_list, secdepartime_list, estimatedtime_list, status_list) mycursor.execute(sql, val) mydb.commit() print(airline_list) print(dest_list) print(flightnumber_list) print(secdepartime_list) print(estimatedtime_list) print(status_list)