Python SQL insert语句仅插入部分记录

import sqlite3

conn = sqlite3.connect('database.db')
cursor = conn.cursor()

# 插入一条记录
cursor.execute("INSERT INTO users (username, email) VALUES (?, ?)", ('John', 'john@example.com'))

# 插入多条记录
records = [('Alice', 'alice@example.com'), ('Bob', 'bob@example.com')]
cursor.executemany("INSERT INTO users (username, email) VALUES (?, ?)", records)

conn.commit()
conn.close()

import sqlite3

conn = sqlite3.connect('database.db')
cursor = conn.cursor()

cursor.execute("INSERT INTO users (username, email) SELECT username, email FROM source_table WHERE username LIKE 'A%'")

conn.commit()
conn.close()