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

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 = ("John", "Highway 21", "Highway 21", "Highway 21", "Highway 21")mycursor.execute(sql, val)mydb.commit()print(mycursor.rowcount, "条记录已插入")

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