mysql导入更改大小

import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(host='localhost',
                                         database='testdb',
                                         user='root',
                                         password='password')

    cursor = connection.cursor()

    # 假设CSV文件名为data.csv，表名为test_table
    with open('data.csv', 'r') as file:
        sql = "INSERT INTO test_table (column1, column2) VALUES (%s, %s)"
        for line in file:
            values = line.strip().split(',')
            cursor.execute(sql, values)

    connection.commit()
    print("Data imported successfully.")

except Error as e:
    print("Error while importing data:", e)

finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("MySQL connection is closed.")