Inerir dados de um arquivo CSV em um banco de dados MySQL com Python.

main.py

import csv
import MySQLdb

mydb = MySQLdb.connect(host='127.0.0.1', user='root', password='', database='all_db')

with open('cars.csv') as csv_file:
    csvfile = csv.reader(csv_file, delimiter=',')
    all_value = []
    for row in csvfile:
        value = (row[0], row[1], row[2])
        all_value.append(value)
        
query = 'INSERT INTO `tbl_cars` (`name`, `company`, `launch_year`) values (%s, %s, %s)'

mycursor = mydb.cursor()
mysurcor.executemany(query, all_value)
mydb.commit()