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: stackoverflow.com/questions/12546267/…

Marc B
– Marc B

2015-06-29 21:01:30 +00:00
Commented Jun 29, 2015 at 21:01 — Marc B
– Marc B, Commented Jun 29, 2015 at 21:01
I tried with the `` notation but same error..

pakoun
– pakoun

2015-06-29 22:15:15 +00:00
Commented Jun 29, 2015 at 22:15 — pakoun
– pakoun, Commented Jun 29, 2015 at 22:15

pakoun · Accepted Answer · 2015-06-29 23:19:10Z

1

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

edited Jun 29, 2015 at 23:19

answered Jun 29, 2015 at 23:13

pakoun

659 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

error when writing variable to mysql via python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related