本文共 2041 字，大约阅读时间需要 6 分钟。

import osfrom tinytag import TinyTagimport 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=0for 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, "条记录已插入")

转载地址：https://blog.csdn.net/weixin_33595571/article/details/109649788 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！