有没有办法将"null“值从数据库写入csv文件？

import csv
import sqlite3

# 连接数据库
conn = sqlite3.connect('example.db')
cursor = conn.cursor()

# 查询数据
cursor.execute("SELECT * FROM your_table")
rows = cursor.fetchall()

# 写入CSV文件
with open('output.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerow([i[0] for i in cursor.description])  # 写入列名
    for row in rows:
        writer.writerow([value if value is not None else '' for value in row])  # 替换NULL值为空字符串

# 关闭连接
conn.close()

import csv
import sqlite3

# 连接数据库
conn = sqlite3.connect('example.db')
cursor = conn.cursor()

# 查询数据
cursor.execute("SELECT * FROM your_table")
rows = cursor.fetchall()

# 写入CSV文件
with open('output.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerow([i[0] for i in cursor.description])  # 写入列名
    for row in rows:
        writer.writerow([value if value is not None else '\\N' for value in row])  # 使用\N表示NULL值

# 关闭连接
conn.close()

COPY your_table TO 'output.csv' WITH (FORMAT csv, NULL '');