如何使用Python在MySQL中创建唯一ID字段

import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(
        host='localhost',
        database='your_database',
        user='your_username',
        password='your_password'
    )
    if connection.is_connected():
        print('连接到MySQL数据库成功')
except Error as e:
    print(f'连接失败：{e}')

cursor = connection.cursor()

create_table_query = '''
CREATE TABLE your_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    other_column VARCHAR(255)
)
'''
cursor.execute(create_table_query)

cursor.close()
connection.close()

import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(
        host='localhost',
        database='your_database',
        user='your_username',
        password='your_password'
    )
    if connection.is_connected():
        print('连接到MySQL数据库成功')

    cursor = connection.cursor()

    create_table_query = '''
    CREATE TABLE your_table (
        id INT AUTO_INCREMENT PRIMARY KEY,
        other_column VARCHAR(255)
    )
    '''
    cursor.execute(create_table_query)

    cursor.close()
    connection.close()
    print('表创建成功')

except Error as e:
    print(f'连接失败：{e}')