import pandas
import MySQLdb


mydb = MySQLdb.connect(
    host='localhost',
    user='',
    passwd='',
    db='mydb',
)

cursor = mydb.cursor()
my_csv = pandas.read_csv("test.csv", usecols=['id', 'title', 'body', 'author_id'])
insert_stmt = '''INSERT INTO `blog_post` (`Id`,`Title`,`Body`,`Author_id`) VALUES (%s, %s, %s, %s)'''


# for row in my_csv:
#     print(row)
#     cursor.execute(insert_stmt, row)

cursor.executemany(insert_stmt, my_csv[1:]

mydb.commit()
cursor.close()
print("done")