mysql文件入库方法

LOAD DATA INFILE '/path/to/your/file.csv'
INTO TABLE your_table
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

LOAD DATA INFILE '/path/to/your/file.csv'
INTO TABLE your_table
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES; -- 忽略文件的第一行（通常是标题行）

GRANT FILE ON *.* TO 'your_user'@'localhost';

LOAD DATA INFILE '/path/to/your/file.csv'
INTO TABLE your_table
CHARACTER SET utf8
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='your_user', password='your_password', db='your_db')
cursor = conn.cursor()

# 文件路径
file_path = '/path/to/your/file.csv'

# SQL语句
sql = """
LOAD DATA INFILE %s
INTO TABLE your_table
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
"""

# 执行SQL语句
cursor.execute(sql, (file_path,))

# 提交事务
conn.commit()

# 关闭连接
cursor.close()
conn.close()