c mysql自动建表

import mysql.connector

# 连接到MySQL数据库
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

mycursor = mydb.cursor()

# 创建表的SQL语句
sql = """
CREATE TABLE customers (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255),
  address VARCHAR(255)
)
"""

# 执行SQL语句
mycursor.execute(sql)

# 提交更改
mydb.commit()

print("Table created successfully!")

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

mycursor = mydb.cursor()

# 检查表是否存在
mycursor.execute("SHOW TABLES LIKE 'customers'")
result = mycursor.fetchone()

if result:
  print("Table already exists.")
else:
  # 创建表的SQL语句
  sql = """
  CREATE TABLE customers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    address VARCHAR(255)
  )
  """
  # 执行SQL语句
  mycursor.execute(sql)
  # 提交更改
  mydb.commit()
  print("Table created successfully!")