0
import csv

mydb = mysql.connector.connect(
    host='localhost',
    user= 'root',
    passwd='xxx',
    db='xxx',
    auth_plugin='mysql_native_password')

cursor = mydb.cursor()
s = open('uniprot_entries_results.csv', mode='r', encoding='utf-8').read()
open('uniprot_entries_results.csv', mode='w', encoding='utf-8').write(s)
print(s)

with open('uniprot_entries_results.csv') as csv_file:
    csv_reader = csv.reader(csv_file, delimiter='\t')
    sql = """INSERT INTO target_information (yourlist:M20200509A94466D2655679D1FD8953E075198DA8AF037EL, Entry, Entry_name, Status, Protein_names, Gene_names, Organism, Length) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)"""
    cursor.executemany(sql, csv_reader)
    mydb.commit()


mydb.close()

Error:mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':M20200509A94466D2655679D1FD8953E075198DA8AF037EL, Entry, Entry_name, Status, Pr' at line 1

RiggsFolly
  • 93,638
  • 21
  • 103
  • 149

0 Answers0