获取mysql主键

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(50) UNIQUE
);

SHOW CREATE TABLE users;

import mysql.connector

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

cursor = db.cursor()

# 查询表结构
cursor.execute("SHOW CREATE TABLE users")

result = cursor.fetchone()

# 解析主键信息
create_table_sql = result[1]
primary_key = None
for line in create_table_sql.split('\n'):
    if "PRIMARY KEY" in line:
        primary_key = line.split()[2].strip('()')
        break

print("主键是:", primary_key)

cursor.close()
db.close()

INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com');