pymysql 插入数据

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='testdb')

try:
    with conn.cursor() as cursor:
        # 插入数据
        sql = "INSERT INTO users (name, email) VALUES (%s, %s)"
        cursor.execute(sql, ('Alice', 'alice@example.com'))
        conn.commit()
except pymysql.MySQLError as e:
    print(f"Error: {e}")
finally:
    conn.close()

conn = pymysql.connect(host='localhost', user='root', password='password', db='testdb')

try:
    cursor.execute(sql, ('Alice', 'alice@example.com'))
    conn.commit()
except pymysql.IntegrityError as e:
    print(f"IntegrityError: {e}")

try:
    with conn.cursor() as cursor:
        sql = "INSERT INTO users (name, email) VALUES (%s, %s)"
        data = [('Alice', 'alice@example.com'), ('Bob', 'bob@example.com')]
        cursor.executemany(sql, data)
        conn.commit()
except pymysql.MySQLError as e:
    print(f"Error: {e}")
finally:
    conn.close()