问SQL语句仅输出列表的最后一行

EN

 import sqlite3
    connection = sqlite3.connect("ios.db")
    cursor = connection.cursor()
    for p in appstore[1:]: 
        format_str = """INSERT INTO Applestore (id, track_name, size_bytes, currency, price, rating_count_tot, rating_count_ver, user_rating, user_rating_ver, ver,  cont_rating, prime_genre, sup_devices_num, ipadSc_url, lang_num, vpp_lic) 
        VALUES ("{id}", "{track_name}", "{size_bytes}", "{currency}", "{price}", "{rating_count_tot}", "{rating_count_ver}", "{user_rating}", "{user_rating_ver}", "{ver}",  "{cont_rating}", "{prime_genre}", "{sup_devices_num}", "{ipadSc_url}", "{lang_num}", "{vpp_lic}");""" 
        sql_command = format_str.format(id = p[0],track_name = p[1],size_bytes = p[2],currency = p[3],price = p[4],rating_count_tot = p[5],rating_count_ver = p[6], user_rating = p[7], user_rating_ver = p[8], ver = p[9], cont_rating = p[10], prime_genre = p[11], sup_devices_num = p[12], ipadSc_url = p[13], lang_num = p[14], vpp_lic = p[15]) 

    cursor.execute(sql_command)


    connection.commit()

    connection.close()

import sqlite3
connection = sqlite3.connect("ios.db")
cursor = connection.cursor()
cursor.execute("""SELECT * FROM Applestore""")
print("fetchall:")
result = cursor.fetchall() 
for r in result:
    print(r)

import sqlite3
connection = sqlite3.connect("ios.db")
cursor = connection.cursor()
for p in appstore:
    format_str = """INSERT INTO Applestore (id, track_name, size_bytes, currency, price, rating_count_tot, rating_count_ver, user_rating, user_rating_ver, ver,  cont_rating, prime_genre, sup_devices_num, ipadSc_url, lang_num, vpp_lic) 
    VALUES (id, track_name, size_bytes, currency, price, rating_count_tot, rating_count_ver, user_rating, user_rating_ver, ver,  cont_rating, prime_genre, sup_devices_num, ipadSc_url, lang_num, vpp_lic);""" 
    #sql_command = format_str.format(id = p[0],track_name = p[1],size_bytes = p[2],currency = p[3],price = p[4],rating_count_tot = p[5],rating_count_ver = p[6], user_rating = p[7], user_rating_ver = p[8], ver = p[9], cont_rating = p[10], prime_genre = p[11], sup_devices_num = p[12], ipadSc_url = p[13], lang_num = p[14], vpp_lic = p[15]) 
    cursor.execute(format_str, (*p[1:16]))


connection.commit()
connetion.close()