import pandas import sqlalchemy as sql import pymysql connect_string = 'mysql+pymysql://stuff' sql_engine = sql.create_engine(connect_string) my_csv = pandas.read_csv('test_dom.csv', usecols=['index', 'id', 'title', 'body', 'author_id']) my_csv.to_sql(con=connect_string, name='blog', if_exists='append')