pymysql建表方法

import pymysql

# 建立数据库连接
connection = pymysql.connect(host='localhost',
                             user='your_username',
                             password='your_password',
                             db='your_database',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

try:
    with connection.cursor() as cursor:
        # 创建表的 SQL 语句
        sql = """
        CREATE TABLE `users` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `username` varchar(255) NOT NULL,
          `email` varchar(255) NOT NULL,
          PRIMARY KEY (`id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
        """
        # 执行 SQL 语句
        cursor.execute(sql)
    # 提交事务
    connection.commit()
finally:
    # 关闭数据库连接
    connection.close()