python 链接 创建 创建表 插入数据 （数据库）

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