import csv
import mysql.connector
import re

result =['2018-10-18_trx_result-reuslt.csv']
mydb = mysql.connector.connect(user='root', password='',
                          host='localhost',
                          database='jeremy_db')
file = open('C:\Users\trendMICRO\Desktop\OJT\test.csv', 'rb')
csv_data = csv.reader(file)
cursor = mydb.cursor()

for row in csv_data:
    cursor.execute('INSERT INTO jeremy_table_test(date_sourced, sha1, vsdt,trendx,notes )' 'VALUES(%s, %s, %s, %s,%s)',row)
mydb.commit()
cursor.close()
print("Done")