如何使用sqlite获取CSV值？

# 打开 SQLite 数据库
sqlite3 mydatabase.db

# 创建一个表
CREATE TABLE mytable (
    id INTEGER PRIMARY KEY,
    name TEXT,
    age INTEGER
);

# 导入 CSV 文件到表中
.import mydata.csv mytable

# 打开 SQLite 数据库
sqlite3 mydatabase.db

# 导出表数据到 CSV 文件
.mode csv
.output mydata_exported.csv
SELECT * FROM mytable;
.exit

import sqlite3
import csv

# 创建 SQLite 数据库和表
conn = sqlite3.connect('mydatabase.db')
cursor = conn.cursor()
cursor.execute('''CREATE TABLE IF NOT EXISTS mytable (
                    id INTEGER PRIMARY KEY,
                    name TEXT,
                    age INTEGER)''')

# 从 CSV 文件导入数据到 SQLite
with open('mydata.csv', newline='') as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
        cursor.execute('INSERT INTO mytable (id, name, age) VALUES (?, ?, ?)',
                       (row['id'], row['name'], row['age']))
conn.commit()

# 从 SQLite 导出数据到 CSV 文件
with open('mydata_exported.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow(['id', 'name', 'age'])  # 写入列标题
    cursor.execute('SELECT * FROM mytable')
    for row in cursor.fetchall():
        writer.writerow(row)

conn.close()