mysql导入一千万数据

import mysql.connector
from mysql.connector import Error

def import_data(file_path):
    try:
        connection = mysql.connector.connect(host='localhost',
                                             database='testdb',
                                             user='root',
                                             password='password')
        cursor = connection.cursor()
        
        # 假设文件是CSV格式，每行包含三个字段：id, name, age
        with open(file_path, 'r') as file:
            sql = "INSERT INTO users (id, name, age) VALUES (%s, %s, %s)"
            for line in file:
                values = tuple(line.strip().split(','))
                cursor.execute(sql, values)
        
        connection.commit()
        print("Data imported successfully!")
    
    except Error as e:
        print(f"Error: {e}")
    
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

# 调用函数导入数据
import_data('data.csv')