error when writing variable to mysql via python

Question

I am trying to insert with python (v 2.7.6) a variable with multiple entries into MySQL (Ver 14.14 Distrib 5.5.43) table. The code is as follows :

cur = con.cursor()
cur.execute("CREATE TABLE IF NOT EXISTS Stations(     \
            StationsID  INT AUTO_INCREMENT,           \
            Code      VARCHAR(3)       ,              \
            PRIMARY KEY pk_Stations (StationsID)      \
            );");

cur.executemany("INSERT INTO Stations (Code) VALUES(?)", sns);

sns variable has the following form:

array(['PAL', 'TT1', 'BAL', 'MHD', 'BI5', 'CB4'],dtype='|S3')

I am getting the following error:

File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 199, in executemany
    if not args: return
ValueError: The truth value of an array with more than one element is ambiguous. Use a.any() or a.all()

Could you please give me a help here?

DUpe: http://stackoverflow.com/questions/12546267/mysql-safely-using-reserved-word-in-query — Marc B, Jun 29 '15 at 21:01

pakoun · Answer 1 · 2015-06-29T23:19:10.550

1

Problem solved. The variable should be a list and it was a numpy array.

edited Jun 29 '15 at 23:19

answered Jun 29 '15 at 23:13

pakoun

65
8

error when writing variable to mysql via python

1 Answers1