mysql导入csv文件日期格式

import csv

input_file = 'input.csv'
output_file = 'output.csv'

with open(input_file, 'r') as infile, open(output_file, 'w', newline='') as outfile:
    reader = csv.reader(infile)
    writer = csv.writer(outfile)
    for row in reader:
        # 假设CSV文件中的日期格式为 DD/MM/YYYY
        row[0] = row[0].replace('/', '-')  # 转换为 YYYY-MM-DD 格式
        writer.writerow(row)

LOAD DATA INFILE 'output.csv'
INTO TABLE your_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(@date_column)
SET date_column = STR_TO_DATE(@date_column, '%d/%m/%Y');

import csv
from datetime import datetime

input_file = 'input.csv'
output_file = 'output.csv'

with open(input_file, 'r') as infile, open(output_file, 'w', newline='') as outfile:
    reader = csv.reader(infile)
    writer = csv.writer(outfile)
    for row in reader:
        try:
            # 假设CSV文件中的日期格式为 DD/MM/YYYY
            date_obj = datetime.strptime(row[0], '%d/%m/%Y')
            row[0] = date_obj.strftime('%Y-%m-%d')
            writer.writerow(row)
        except ValueError:
            # 处理无效日期
            pass

LOAD DATA INFILE 'output.csv'
INTO TABLE your_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(@date_column)
SET date_column = CASE
    WHEN @date_column REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2}$' THEN @date_column
    ELSE NULL
END;