python sql 批量插入添加数据

import os
from tinytag import TinyTag
import mysql.connector

#   database 链接数据库
mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  passwd="123456",
  auth_plugin='mysql_native_password',
  database="Testdatabase"
)

mycursor = mydb.cursor()
#c  创建数据库
'''
mycursor = mydb.cursor()
mycursor.execute("CREATE DATABASE mydatabase")
'''
#创建表单
#mycursor.execute("CREATE TABLE Tname6 (place VARCHAR(255), artist VARCHAR(255), duration VARCHAR(255), album VARCHAR(255), title VARCHAR(255),id INT AUTO_INCREMENT PRIMARY KEY))")
#mycursor.execute("CREATE TABLE Tname7 (place VARCHAR(255), artist VARCHAR(255), duration VARCHAR(255), album VARCHAR(255), title VARCHAR(255), id INT AUTO_INCREMENT PRIMARY KEY)")
#插入数据

sql = "INSERT INTO Tname7 (place, artist,duration,album,title) VALUES (%s, %s, %s, %s,%s)"
#val = ("fff", "ssss", "fsdfsdf", "Highway 21", "Highway 21")

#批量录入数据
path="E:\\KwDownload\\抖音伤感抖音伤感热歌"
MusicFileList=[]
MusicFileCount=0
for root,dirs,files in os.walk(path):
    for name in files:
        MusicFileTuple=()
        if name.endswith(".mp3") or name.endswith(".wav") or name.endswith(".mp4"):
            print(os.path.join(root,name))
            #MusicFileList.append(os.path.join(root,name))
            tag = TinyTag.get(os.path.join(root,name))
            print(tag.artist)
            #MusicFileList.append(tag.artist)
            print(tag.duration)
            #MusicFileList.append(tag.duration)
            print(tag.album)
            #MusicFileList.append(tag.album)
            print(tag.title)
            #MusicFileList.append(tag.title)
            MusicFileTuple=(os.path.join(root,name),tag.artist,tag.duration,tag.album,tag.title)
            MusicFileCount=MusicFileCount+1
            DBval=(str(os.path.join(root,name)),str(tag.artist),str(tag.duration),str(tag.album),str(tag.title))
            mycursor.execute(sql,DBval)
        MusicFileList.append(MusicFileTuple)


print(MusicFileCount)
print("&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&")
print(MusicFileList)
print("&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&")

mydb.commit()
print(mycursor.rowcount, "条记录已插入")